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 |
|
senpoly
Starting Member
19 Posts |
 Posted - 2007-07-31 : 10:00:11
|
| hi friendsi got a error message while running a spthat sp run successfully, yesterday, but today its showing the following errorA severe error occured on the current command.The results, if any, should be discarded.can any help me, in this regardsenthil kumar |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2007-07-31 : 10:16:49
|
| and that is all of the error message you get?no inner exception?no stack trace?no nothing?_______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenp |
 |
|
|
senpoly
Starting Member
19 Posts |
Posted - 2007-07-31 : 10:36:05
|
| Msg 0, Level 11,State 0, Line 0A severe error occured on the current command.The results, if any, should be discarded.Msg 0, Level 20,State 0, Line 0A severe error occured on the current command.The results, if any, should be discarded.this was the exact error message i am gettingregardssenthil |
|
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2007-07-31 : 10:41:30
|
| try commenting or removing any print statements that you have._______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenp |
|
|
|
senpoly
Starting Member
19 Posts |
Posted - 2007-07-31 : 10:42:57
|
| i have removed the print commands already but the problem persists stillregardssenthil |
|
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2007-07-31 : 10:53:07
|
| put SET NOCOUNT ONas the first statement in your sproc_______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenp |
|
|
|
|
|
|
|
|
A Severe error occured on the current command