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

Data Dictionary using sys.objects - SQL 2008 Expand / Collapse
Author
Message
Posted Thursday, October 21, 2010 1:02 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Sunday, February 09, 2014 8:27 PM
Points: 198, Visits: 223
Comments posted to this topic are about the item Data Dictionary using sys.objects - SQL 2008


Post #1008205
Posted Thursday, October 21, 2010 2:49 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, January 26, 2011 1:32 PM
Points: 146, Visits: 327
Tony,

Your old code you reference does not work - http://www.sqlservercentral.com/scripts/Maintenance+and+Management/31760/ - Invalid column name 'SchemaName' - you need to add that to the data.Dictionary definition.

Best,
Doug
Post #1008828
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse