Data Dictionary - SQL 2005

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

  • 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.

  • 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 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply