Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2011
    Posts
    2

    Thumbs down Unanswered: MS_Description and description on design grid

    Hello,

    I created lots of tables in my SQL Server 2008 database. I added descriptions to each field using sp_addextendedproperty and (ms_description property).

    Now this seems to be an action equal to when I add this comment in the table design view to the Description field.

    However, if I use the stored procedure to add comments, design grid will not display the comment (and of course, results in error if I try to add on there, 'cos there's already a value for that property).

    My pain is that I have a sexy tool namely BI Documenter that creates a handy help file (.chm format) for the database. It does not recognise any comments added by the sp_addextendedproperty, but it does so, when a comment to a field is added through the table design view.


    Since the same MS_Description property is edited in 2 ways, I really have no clue, how on earth can it still make a distinction and not display a comment added by an sp.

    I want to be able to compile this help file with comments without having to rewrite the descriptions manually again.

    Ideaz?

  2. #2
    Join Date
    Sep 2011
    Posts
    71
    Hello Clapton79 ,
    first i share your pain ,
    second i found a helpful article to us ,which me be v helful to u too
    Fun with Extended Properties in SQL Server 2008 | Glenn Berry's SQL Server Performance

  3. #3
    Join Date
    Oct 2011
    Posts
    2

    Unhappy hello

    Paul,
    Thanks for the answer.
    I've read through the article and it says exactly what I did: use sp_addextendedproperty.

    I made an excel table with functions that compile a CREATE TABLE script so I can easily build up a table with lots of tables along standards. So I used this, instead of adding Description in the table design view.

    It did speed up my work, but now I'm in trouble and this article is not giving me a hand.

    This IS Microsoft. Have every feature accessible from hundreds of places. And then find out what the difference in the behaviour might be...

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •