Post reply

Database documantation

  • May 20, 2009 at 3:00 am

    #209680

    Halo mates

    I am doing a database documantation and i need help with the script that generates datadictonary in html with (primary keys etc etc) i am very thankful with all the tricks and tips you can give me about documantation

    Best regards

    Jakob

  • May 20, 2009 at 3:15 am

    #997466

    --ContentExport table--

    EXEC sp_addextendedproperty

    @name = N'Caption', @value = 'This column contains email for contacts.',

    @level0type = N'Schema', @level0name = dbo,

    @level1type = N'Table', @level1name = dbo.ContentExport,

    @level2type = N'Column', @level2name = DocID;

    GO

    Msg 102, Level 15, State 1, Line 6

    Incorrect syntax near '.'.

    why?

  • May 20, 2009 at 3:46 am

    #997473

    Just put single quotes round dbo.ContentExport, i.e.

    EXEC sp_addextendedproperty

    @name = N'Caption', @value = 'This column contains email for contacts.',

    @level0type = N'Schema', @level0name = dbo,

    @level1type = N'Table', @level1name = 'dbo.ContentExport',

    @level2type = N'Column', @level2name = DocID;

    The parameter @level1name is of type sysname, which is a string. SQL server won't automatically cast dbo.ContentExport to a string because of the ".".

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply