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 |
|
akhilreddy
Starting Member
1 Post |
 Posted - 2013-09-22 : 10:12:16
|
| we are using SQl server 2008 database in our organization.Is there any way to stop sql query execution ?.we have around 1000k records in database instead of deleting one record its deleting all the records from the database..please help me urgent to stop that execution |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2013-09-22 : 10:49:53
|
| Execute thisEXEC sp_whoand findout the spid of the DELETE statement and execute the followingKILL spidwhere spid is the value that you find it from the first codeMadhivananFailing to plan is Planning to fail |
 |
|
|
|
|
|
Delete Records