Why do descriptions disappear?

SnowstyxSnowstyx Posts: 2 New member
Hey all,
I'm tasked with documenting a server, and one of the key features of sql doc is that it allows you to put a description for a field. I'm curious why some of these fields disappear. I can save a project, and check a few days later to see some of the definitions missing.


Best Answer

  • sam.blackburnsam.blackburn Posts: 224 Gold 2
    Accepted Answer
    The "MS_Description" field isn't actually saved in your project file at all - a tooltip over the save button indicates that SQL Doc adds an extended property to the object in the database:

    What is probably happening here is a few objects are being dropped and recreated by other people with access to the database, which causes them to lose their extended properties.
    Software Developer
    Redgate Software


  • Either that, or the "Save to database" button isn't being pressed in which case - as Sam says - the field isn't saved in the project file so it won't be stored there and hasn't been saved to the database.

    Kind regards,
    Product Support Engineer | Redgate Software

    Have you visited our Help Center?
  • SnowstyxSnowstyx Posts: 2 New member
    Sam was correct in his assumption. We do nightly refreshes that drop our tables. I've gone ahead, and started using SQL Compare to use a snapshot to save and deploy the extended properties to a test database anytime we do want to use them for document generation.
Sign In or Register to comment.