Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
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 Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, February 10, 2016 5:03 AM
Points: 201, Visits: 237
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