Need a possibility to change Extended Properties ...

masi · September 7, 2010 9:52AM

If you make use of Extended Properties functionality in SQL Server 2008 you can see the information in SQL Doc 2 but you can not change it.

Need a mechanism to be able to change Extended properties via the tool.

Will that be possible ?

David Atkinson · September 7, 2010 11:04AM

Thanks for the suggestion. Is there any reason why this isn't something you can modify in the SSMS properties dialog? Is it something you think is more suited in the SQL Doc UI?

David Atkinson
Product Manager
Red Gate Software

masi · September 7, 2010 1:02PM

Right - I can do it by using SSMS BUT SQL Doc will be much more user friendly.

Of course there is also a possibility to use simple SQL-statements but that's not really what we want to do. The maintanace of all Extended Props will be made by end-users responsible for all meta-data for a huge database system.

David Atkinson · September 7, 2010 3:47PM

Ah - that's interesting. Do the end users who will be making those changes have SSMS on their desktops or will they only have SQL Doc?

David

masi · September 7, 2010 4:37PM

They will only have SQL doc. No intention to roll out SSMS.

David Atkinson · September 7, 2010 4:38PM

Thanks for the additional info.

How would this best work for you in SQL Doc? Is the current interface adequate, or should there be an easier way to input this information?

David

masi · September 8, 2010 6:15AM

The current interface is absolutely adequate.

Thanks !

David Atkinson · September 8, 2010 6:57AM

Would you need to add new extended properties from SQL Doc, or do you only need to edit exsiting ones?

David

masi · September 8, 2010 11:27AM

We need to add new extended properties as well as maintanence of already entered Extended Props.

masi · October 21, 2010 8:10AM

David Atkinson · October 21, 2010 9:18AM

We'd really like to accommodate this feature in a future release, but we can't at this stage make any short term promises. At the moment we fully recognize that just supporting the one extended property, MS_Description is restrictive to many.

Kind regards,

David

joshturley · November 22, 2010 12:41PM

We have about 7 extra properties we'd like to include with our database documentation for each field in out tables. Being able to edit and add these is key.

David Atkinson · November 22, 2010 12:44PM

How would you want these to be accommodated in the documentation? (in terms of layout)

fargs · February 28, 2013 2:40PM

It looks like this has been requested and tracked for a very long time (SDOC-775). I am updated to the latest version of SQL Doc and it is still not implemented. Is this going to happen? It would be a very useful feature. It doesn't necessarily have to be in SQL Doc. It could be a plug in to SSMS. I am currently using this for free.

http://datadictionary.codeplex.com/

Thanks,

Need a possibility to change Extended Properties ...

Comments

Product Learning

Community Forums

Events & Friends

Simple Talk