Data Documenter not saving Descriptions
-
- Posts: 15
- Joined: Fri 09 Nov 2012 20:10
Data Documenter not saving Descriptions
I am unable to get descriptions for tables and fields to successfully save to the ddoc file. If I save descriptions into their fields using documenter, save the file and then close the documenter and reopen it, all the descriptions disappear.
-
- Posts: 15
- Joined: Fri 09 Nov 2012 20:10
Re: Data Documenter not saving Descriptions
Update: Does Documenter work with Azure databases? Because I think I'm seeing that it works to save descriptions on my local databases, but doesn't work on Azure databases. Does it store the description in the database metadata? If so, I could see why Azure may not work...
-
- Posts: 15
- Joined: Fri 09 Nov 2012 20:10
Re: Data Documenter not saving Descriptions
Further info: When I save a description from documenter, I can see that it does save to the extended properties in the Azure SQL database using the following query:
However, when I close out of the documenter and re-open it, it appears that the documenter isn't loading the properties back into fields correctly.
Thanks!
Code: Select all
SELECT * FROM sys.extended_properties
Thanks!