Customer Engagement & Dynamics CRM Forum

Expand all | Collapse all

Help! Column manually added to Table in SQL removed - what's the impact?

Jump to Best Answer
  • 1.  Help! Column manually added to Table in SQL removed - what's the impact?

    GOLD CONTRIBUTOR
    Posted 11 days ago
    ​Yesterday while I was out of town, someone added a column to a custom entity table in our CRM Database DEV environment via SQL.
    They then removed the new column via SQL.
    Should I not worry? What's the impact?
    I am concerned because we use our DEV environment to create custom solutions that we'll push forward into our other environments.
    Specifically, I need to create a column of the same name now that I'll add via the CRM UI (to have the proper connections, indexing, etc) added.
    Help!


    ------------------------------
    Allison Briden
    Business Systems Analyst
    Energy Trust of Oregon
    Portland OR
    ------------------------------


  • 2.  RE: Help! Column manually added to Table in SQL removed - what's the impact?

    TOP CONTRIBUTOR
    Posted 11 days ago
    You're almost certain to get a data type error trying to recreate the column.  Deleting via SQL is unsupported, and there's a good chance the API still has that field registered as valid, meaning trying to recreate it in the UI will be at minimum problematic.

    Or it could be nothing, give it a shot.

    ------------------------------
    Wayne Walton
    Senior Solutions Architect
    Hitachi Solutions America, Ltd.
    Atlanta GA
    ------------------------------



  • 3.  RE: Help! Column manually added to Table in SQL removed - what's the impact?
    Best Answer

    TOP CONTRIBUTOR
    Posted 10 days ago

    Allison

    This shouldn't be a problem since the underlying db is still SQL. But then again if it does, why not just "refresh" DEV? Although I would publish the entity first before adding the "same name" field.

    Ps. I would also remove some sql privileges to prevent this from happening in the future.



    ------------------------------
    Rex Kenley Tan, MCSD: App Builder
    Tallmadge OH
    https://www.youracclaim.com/users/rex-kenley-tan

    *Always be CURRENT with JavaScript & C#, NEVER be obsolete.

    DISCLAIMER: All views expressed on this site are my own and DO NOT represent the opinions of ANY entity whatsoever with which I have been, am now, or will be affiliated.
    ------------------------------



  • 4.  RE: Help! Column manually added to Table in SQL removed - what's the impact?

    MICROSOFT MVP
    Posted 10 days ago
    Yes you should be worried that you have person in your organization that thinks they should be working with the CRM database directly. But that person should be talked to and be terrified that their job is at risk if they ever do something like that again. And as @Rex Kenley Tan says, they need their security rights updated, unless of course it was the VP of IT that was messing around.​

    ------------------------------
    Jerry Weinstock
    Business Technology Strategist, MVP
    CRM Innovation
    Lenexa KS
    https://mvp.microsoft.com/en-us/PublicProfile/4029113?fullName=Jerry%20%20Weinstock
    ------------------------------



  • 5.  RE: Help! Column manually added to Table in SQL removed - what's the impact?

    SILVER CONTRIBUTOR
    Posted 10 days ago
    Next time bring your sql server with you when you go out of town!

    Jokes aside, as it was created in SQL, there should not be any entries regarding this column in metadata tables that are bound to CRM customizations.
    But this is a place where thankfully only few people went, and no one came back to share their stories. so as others said you should just try to re-create this field and check if it works as expected.

    ------------------------------
    Fabien Bernard
    CRM Developer
    Montréal QC
    ------------------------------



  • 6.  RE: Help! Column manually added to Table in SQL removed - what's the impact?

    GOLD CONTRIBUTOR
    Posted 10 days ago
    Thanks to @Wayne Walton, @Rex Kenley Tan, @Jerry Weinstock, and @Fabien Bernard for your helpful, supportive, and fun suggestions!
    I'm going to do a refresh of the DEV environment and adjust some CRM permissions. :)
    ​​​​​

    ------------------------------
    Allison Briden
    Business Systems Analyst
    Energy Trust of Oregon
    Portland OR
    ------------------------------



If you've found this thread useful, dive deeper into User Group community content by role