Why do descriptions disappear?

SnowstyxSnowstyx Posts: 2 New member
in SQL Doc
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.

Tagged:
· Share on Twitter

Best Answer

  • sam.blackburnsam.blackburn Posts: 224 Gold 2
    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
    · Share on Twitter

Answers

  • Alex BAlex B Posts: 1,157 Diamond 4
    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,
    Alex
    Product Support Engineer | Redgate Software

    Have you visited our Help Center?
    · Share on Twitter
  • 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.
    · Share on Twitter
Sign In or Register to comment.