title: Stopping the Delete Operation in SQL Server
body: <p>I wanted to delete massive amount of data on a SQL Server 2005 table (about 80 millions of records). Without stating <code>begin tran</code>, I wrote my delete query like </p>
  
  <pre><code>Delete from myTable 
  where columnA &gt; X' 
  </code></pre>
  
  <p>where <code>columnA</code> is not the table's primary key. It has been started since 4 hours ago and still not finished. I've tested in a similar scenario with similar number of rows and similar condition and the operation was done in about 70 minutes but meanwhile the main server is more powerful but it is not stopping after 4 hours being spent. The database has been configured to provide <code>Full recovery</code> model. </p>
  
  <p>I want to know if I can stop this never ending operation by killing the SPID of the corresponding process, and If I done so, what happens? Will sql server start to rollback the operation? will the database gets suspended? What is the solution?</p>