September 24, 2007 at 12:30 pm
Comments posted to this topic are about the item Data Dictionary - SQL 2005
April 2, 2009 at 11:28 am
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.
March 17, 2010 at 8:40 am
The script created the table, but the table is empty. How do I populate it with the tables in my particular database?
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply