Data Dictionary - SQL 2005

• sqldummy79

  SSC-Addicted

  Points: 491

  More actions

  September 24, 2007 at 12:30 pm

  #175140

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

• tstapenhorst

  SSC Enthusiast

  Points: 134

  More actions

  April 2, 2009 at 11:28 am

  #970954

  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.

• Beverly Slater

  SSC Rookie

  Points: 37

  More actions

  March 17, 2010 at 8:40 am

  #1135289

  The script created the table, but the table is empty. How do I populate it with the tables in my particular database?