How can we help you today? How can we help you today?

Need a possibility to change Extended Properties ...

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 ?
masi
0

Comments

13 comments

  • David Atkinson
    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
    David Atkinson
    0
  • masi
    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.
    masi
    0
  • David Atkinson
    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
    David Atkinson
    0
  • masi
    They will only have SQL doc. No intention to roll out SSMS.
    masi
    0
  • David Atkinson
    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
    David Atkinson
    0
  • masi
    The current interface is absolutely adequate.

    Thanks !
    masi
    0
  • David Atkinson
    Would you need to add new extended properties from SQL Doc, or do you only need to edit exsiting ones?

    David
    David Atkinson
    0
  • masi
    We need to add new extended properties as well as maintanence of already entered Extended Props.
    masi
    0
  • masi
    Just checking if there is any progress on this case ...

    Best regards
    Matti Sirén
    masi
    0
  • David Atkinson
    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
    David Atkinson
    0
  • joshturley
    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.
    joshturley
    0
  • David Atkinson
    How would you want these to be accommodated in the documentation? (in terms of layout)
    David Atkinson
    0
  • fargs
    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,
    fargs
    0

Add comment

Please sign in to leave a comment.