LOL. I'll let him know that for that next run away SP :)
>You can always bounce the server ;-)
>
>-Mike
>
>>We tried that and it didn't show up. Fortunately it was development mode, so he just deleted and recreated the table.
>>
>>
>>>>A co-worker has written a stored procedure that when triggered writes a record to a table. Well, the SP is now caught in an infinite loop, and neither one of us know how to stop it. Any suggestions?
>>>
>>>Start EM and go to Management -> Current Activity -> Process Info. Find Process under which SP is running, right click on it and select Kill Process.
red
Rodney E. Dixon
Mckee Foods Corporation
Collegedale, TN