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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2006-01-25 : 08:17:44
|
| Binh writes "Hi SQLTeam,I have a return error message that is strange. here is the error message:Mail sent.Msg 0, Level 11, State 0, Line 0A severe error occurred on the current command. The results, if any, should be discarded.here is the setup, both server are sql2000. server A is linked to server B. Server B hold the store procedure sqlemailer, that takes three parameters. The SP works fine on serverB, there are job that uses it for many months and no problem, that is not the issue. The issue is when server A calls the store procedure. It return a success but also the error message. The emails goes out but also return a error. I created another test Store procedure that have all parameter to call the SQLEMAIler procedure but same problem. All other SQL command works with no problemANy idea?Thank You Binh" |
|
|
|
|
|
Store Procedure call thur Linked server return error