InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 22 May 2013 13:43:36 GMT20http://www.sqlservercentral.com/Forums/Topic1166383-391-1.aspxDownload SSMS Tools Pack - http://www.ssmstoolspack.com/then add the following custom script.[code="other"]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_USEREXEC 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[/code]Wed, 16 Jan 2013 08:11:25 GMTjasonclements32304http://www.sqlservercentral.com/Forums/Topic1166383-391-1.aspxThis might be something Mladen Prajdić 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 [url=http://www.sqlservercentral.com/Forums/FindPost1175462.aspx]just posted about it here[/url], 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.Thu, 15 Sep 2011 02:40:11 GMTTao Klerkshttp://www.sqlservercentral.com/Forums/Topic1166383-391-1.aspxNo 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.Wed, 14 Sep 2011 11:45:38 GMTSantiago E. Perezhttp://www.sqlservercentral.com/Forums/Topic1166383-391-1.aspxJust 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,Fri, 26 Aug 2011 13:04:10 GMTSantiago E. Perez