Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SSMS Add-in for Extended Property MS_Description Expand / Collapse
Author
Message
Posted Friday, August 26, 2011 1:04 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, November 3, 2011 10:55 AM
Points: 19, Visits: 71
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,
Post #1166383
Posted Wednesday, September 14, 2011 11:45 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, November 3, 2011 10:55 AM
Points: 19, Visits: 71
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.
Post #1175158
Posted Thursday, September 15, 2011 2:40 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, September 25, 2014 12:38 PM
Points: 1,385, Visits: 1,249
This 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 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.
Post #1175465
Posted Wednesday, January 16, 2013 8:11 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Friday, September 26, 2014 1:25 PM
Points: 18, Visits: 166
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

Post #1407862
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse