SSMS Add-in for Extended Property MS_Description

Question

SSMS Add-in for Extended Property MS_Description

Santiago E. Perez

Right there with Babe

Points: 715
More actions
August 26, 2011 at 1:04 pm

#242283

Just wondering if anyone has seen any SSMS add-in for easily adding / updating Description meta data for different objects, mainly tables and columns? Looking for something that can be like a context menu with a text box to insert/change Description rather than having to go into design mode etc.
Thanks in advance,

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

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

Santiago E. Perez Right there with Babe Points: 715 More actions · Answer 1

No suggestions? Tried looking into creating my own and although doesn't look impossible just would hate to kick myself for spending hours on something that's already been done and relatively feasible.

Tao Klerks SSCarpal Tunnel Points: 4297 More actions · Answer 2

This might be something Mladen Prajdic would consider adding to his popular "SSMS Tools Pack" add-in, should be very quick to include! Have you considered contacting him to find out?

I created an add-in a few months ago (I just posted about it here, actually), and the difficulty is not so much the development as the management of the install process, versioning, etc; if you want to make it available to others it's a pain, you need an installer and everything.

I'd be happy to look at adding it to the SQL Formatter add-in, but it's a little off-topic - would be more of a secret feature than anything else :-). Let me know if you'd like me to have a go at adding that in the next version, or if you find a better solution.

http://poorsql.com for T-SQL formatting: free as in speech, free as in beer, free to run in SSMS or on your version control server - free however you want it.

jasonclements32304 Ten Centuries Points: 1122 More actions · Answer 3

Download SSMS Tools Pack - http://www.ssmstoolspack.com/

then add the following custom script.

DECLARE @type varchar(50), @timestamp DATETIME, @user VARCHAR(100)

SELECT @type=CASE WHEN [type] = 'U'

THEN 'TABLE'

WHEN [type] = 'V'

THEN'VIEW'

WHEN [type] = 'P'

THEN 'PROCEDURE

WHEN [type] = 'PK'

THEN 'PRIMARY_KEY_CONSTRAINT'

WHEN [TYPE] = 'D'

THEN 'DEFAULT_CONSTRAINT'

WHEN [type] = 'FN'

THEN 'SQL_SCALAR_FUNCTION'

END

FROM sys.objects

WHERE [NAME] = '|ObjectName|'

SELECT @timestamp=GETDATE()

SELECT @user=SYSTEM_USER

EXEC sys.sp_addextendedproperty @name=N'Created by', @value=@user , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=@type,@level1name=N'|ObjectName|'

EXEC sys.sp_addextendedproperty @name=N'Purpose', @value=N'' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=@type,@level1name=N'|ObjectName|'

EXEC sys.sp_addextendedproperty @name=N'Created on', @value=@timestamp, @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=@type,@level1name=N'|ObjectName|'

GO