Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Stoping an Endless Loop

Status
Not open for further replies.
Mike555

Mike555

Technical User
Joined
Feb 21, 2003
Messages
1,200
Location
US
I accidentally executed a continuous Loop that is now constantly running a stored procedure on my SQL Server. When I open up Profiler I can see it continually running. How can I stop this? Thanks.

--
Regards,
Mike
 
Sort by date Sort by votes
Well if you are running it from query analyzer, you can just click the cancel query execution button.

Or I suppose you could go into Enterprise Manager and kill the SPID that is running it.

Questions about posting. See faq183-874
Click here to learn Ways to help with Tsunami Relief
 
Upvote 0 Downvote
Thanks for your reply - I simply stopped and restarted the service and that worked also.

--
Regards,
Mike
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Triacona
  • Locked
  • Question Question
How to broadcast data from a SQL server to an IP an Port
Replies
5
Views
699
fisheromacse
fisheromacse
DougNaf
  • Locked
  • Question Question
SQL 2016 - DB attachment and error 3415
Replies
1
Views
669
fredericofonseca
fredericofonseca
JoPaBC
  • Locked
  • Question Question
Delphi/Borland program and SQL Express 2017
Replies
6
Views
1K
JoPaBC
JoPaBC
JoPaBC
  • Locked
  • Question Question
Schedule and automate backups of SQL Express databases in SQL Server Express
Replies
5
Views
1K
JoPaBC
JoPaBC
tekpr00
  • Locked
  • Question Question
Backups in a multiserver environment while using Central Management Server and Server Groups
Replies
0
Views
426
tekpr00
tekpr00

Part and Inventory Search

Sponsor

Back
Top