SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Data Dictionary - SQL 2005


Data Dictionary - SQL 2005

Author
Message
sqldummy79
sqldummy79
SSC Veteran
SSC Veteran (215 reputation)SSC Veteran (215 reputation)SSC Veteran (215 reputation)SSC Veteran (215 reputation)SSC Veteran (215 reputation)SSC Veteran (215 reputation)SSC Veteran (215 reputation)SSC Veteran (215 reputation)

Group: General Forum Members
Points: 215 Visits: 237
Comments posted to this topic are about the item Data Dictionary - SQL 2005



tstapenhorst
tstapenhorst
Grasshopper
Grasshopper (10 reputation)Grasshopper (10 reputation)Grasshopper (10 reputation)Grasshopper (10 reputation)Grasshopper (10 reputation)Grasshopper (10 reputation)Grasshopper (10 reputation)Grasshopper (10 reputation)

Group: General Forum Members
Points: 10 Visits: 138
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
Beverly Slater
Forum Newbie
Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)

Group: General Forum Members
Points: 3 Visits: 18
The script created the table, but the table is empty. How do I populate it with the tables in my particular database?
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search