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 |
|
sirmilt
Starting Member
49 Posts |
 Posted - 2011-11-05 : 13:53:32
|
| I am using SQL Server 2008R2 with the management Studio.I am trying to create a new, very simple query and after it Parses successfully and I try to Execute I get the error "sg 2812, Level 16, State 62, Line 1 Could not find stored procedure 'qryTruncateLoans'."There is no other query with this name , and I can't figure out why I am getting the error.Milt |
|
|
Transact Charlie
Master Smack Fu Yak Hacker
3451 Posts |
Posted - 2011-11-05 : 14:42:07
|
| when you parse the sql it won't pick up certain things such as missing stored procs or the existance of temp tables. All of that is done at execution time.Can you post the sql of the stored proc?My quess is either:1) You sql calls a sp which in turn trys to call qryTruncateLoans. This doen't exist on the db you are on2) There is a trigger that fires that does something.Without seeing the code (and even then if it's an environmental thing then.....) we can't help.Charlie===============================================================Msg 3903, Level 16, State 1, Line 1736The ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION |
 |
|
|
sirmilt
Starting Member
49 Posts |
Posted - 2011-11-05 : 15:48:13
|
| Thank you for the response.This seems to be an intermittent response. Since my original post earlier today, I did the following:1) Clicked Query/Parse - - Result was successful2) Clicked Query/Execute - - Result was the error described previouslyWith no changes and no intermittent activity I repeated the sequence and the query executed as expected.All is fine except for my curiosity as to why the error happened in the first place.Milt |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-11-06 : 02:38:43
|
quote:
Originally posted by sirmilt
Thank you for the response.This seems to be an intermittent response. Since my original post earlier today, I did the following:1) Clicked Query/Parse - - Result was successful2) Clicked Query/Execute - - Result was the error described previouslyWith no changes and no intermittent activity I repeated the sequence and the query executed as expected.All is fine except for my curiosity as to why the error happened in the first place.Milt
may be you were not selecting the whole query and executing only part of it. to understand more, we need to see what query you were trying to execute. may be you were creating and executing the procedure in same batch which caused this error.------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|
|
|
|
New Stored Procedure