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 - SQL 2005 Expand / Collapse
Author
Message
Posted Monday, September 24, 2007 12:30 PM
SSC-Enthusiastic

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

Group: General Forum Members
Last Login: Sunday, February 9, 2014 8:27 PM
Points: 198, Visits: 223
Comments posted to this topic are about the item Data Dictionary - SQL 2005


Post #402196
Posted Thursday, April 2, 2009 11:28 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, August 28, 2013 9:18 AM
Points: 7, Visits: 127
Hi Toby,

I get the following error running the script the first time:

Msg 2812, Level 16, State 62, Line 51
Could not find stored procedure 'SP_EXECUTESQL'.

I don't find that stored procedure. When I ran it a second time, after I deleted the Data table in the AdventureWorks database , I get the following error messages:

Msg 2714, Level 16, State 6, Line 4
There is already an object named 'Data' in the database.
Msg 2759, Level 16, State 0, Line 4
CREATE SCHEMA failed due to previous errors.
Msg 2812, Level 16, State 62, Line 51
Could not find stored procedure 'SP_EXECUTESQL'.

and a whole bunch of Msg 2812s after that. I'm new to SQL programming, as I'm coming from the Admin side of the planet. I'm working my way through a book called, "Beginning SQL Server 2005 Programming," by Robert Vieira. Any advice you can offer is sure appreciated. Thanks, Ted.
Post #689195
Posted Wednesday, March 17, 2010 8:40 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, January 30, 2014 11:22 AM
Points: 1, Visits: 18
The script created the table, but the table is empty. How do I populate it with the tables in my particular database?
Post #884734
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse