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 - 2007-03-20 : 09:05:30
|
| Lou writes "Hello,I would like some help correcting a problem with a stored procedure. I made a mistake and created a loop that is never going to end. Now I can't alter the procedure because it's in use. What can I do?Thanks,Lou" |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-03-20 : 09:26:18
|
| How did you start the procedure? Query window? Stop the running.In worst case scenario, you have to stop SQL Server service and restart it.Peter LarssonHelsingborg, Sweden |
 |
|
|
john.burns
Posting Yak Master
100 Posts |
Posted - 2007-03-20 : 10:51:05
|
| In EM drill into management/current activity/process infofind relevant pid and 'kill' process |
|
|
|
|
|
|
SP has an infinite loop and I can't alter it