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 - 2003-05-06 : 08:00:22
|
| Louie writes "On occasion our SQL server pegs out the proc because a sp has gone crazy. We recompile it (the sp) and everything is OK. In the evenings when I'm not around, I would like for our techs to be able to send an e-mail to the sql server, with a secret code in the subject line, to have it run a sp_recompile on the troubled sp. I don't want to put the sp_recompile query in the message body in case they type it wrong. I would rather have the server watch for the "secret code" in the subject and the server will just know what to do.Thanks" |
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2003-05-06 : 10:09:30
|
| Is that like double secret probation?Brett8-) |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-05-06 : 12:21:30
|
quote:
Louie writes "On occasion our SQL server pegs out the proc because a sp has gone crazy. We recompile it (the sp) and everything is OK. In the evenings when I'm not around, I would like for our techs to be able to send an e-mail to the sql server, with a secret code in the subject line, to have it run a sp_recompile on the troubled sp. I don't want to put the sp_recompile query in the message body in case they type it wrong. I would rather have the server watch for the "secret code" in the subject and the server will just know what to do.Thanks"
This sounds like a very bad idea. You need to figure out why the "sp has gone crazy" and not come up with a band-aid. Why don't you post the code to the stored procedure here and we'll see if it can be optimized.Tara |
|
|
|
|
|
|
send mail to the SQL server and have it run a sp.