>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.