Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AdamWest
Constraint Violating Yak Guru
360 Posts |
 Posted - 2010-07-23 : 09:43:59
|
| HI The following is a long SQL but there is an error message that might be easy to find, I am having trouble locating the problem. http://pastebin.com/aAq8Tu8MThe error message is: Msg 2812, Level 16, State 62, Line 1Could not find stored procedure 'SUPPL'. |
|
|
Lamprey
Master Smack Fu Yak Hacker
4614 Posts |
Posted - 2010-07-23 : 12:15:04
|
| I noticed at the top there is a USE statement that points to [test_suppl] and down in the code it references teh DB SUPPL. Does the database SUPPL exist on the server you are executing on?Also have you tried running each "chuck" individually to see if it errors? |
 |
|
|
Kristen
Test
22859 Posts |
Posted - 2010-07-23 : 12:29:26
|
| Is that a Runtime error? no line number / filename location?. or an error running that script (don't think there are any syntax errors in the script, unless whatever is running it is truncating it or somesuch) |
|
|
|
|
|
|
SQL code does not compile