Data Dictionary - SQL 2005

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Toby Rogers » Data Dictionary - SQL 2005

Data Dictionary - SQL 2005

Rate Topic

Display Mode

Topic Options

Author

Message

sqldummy79

Posted Monday, September 24, 2007 12:30 PM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, March 07, 2013 7:55 AM
Points: 198, Visits: 205

Comments posted to this topic are about the item Data Dictionary - SQL 2005

Post #402196

tstapenhorst

Posted Thursday, April 02, 2009 11:28 AM

Forum Newbie

Group: General Forum Members
Last Login: Wednesday, December 26, 2012 1:42 PM
Points: 7, Visits: 117

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

Beverly Slater

Posted Wednesday, March 17, 2010 8:40 AM

Forum Newbie

Group: General Forum Members
Last Login: Thursday, January 13, 2011 10:50 AM
Points: 1, Visits: 16

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 »

Permissions