title: SQL Server 2008 database timeout after delete
body: <p>I'm running the following statement, it is working locally with SQL Server 2008, however, there is SQL Server 2008 Express on the development server, and after the sql statement runs, I am unable to do SELECT statements on the table in which I deleted the record.  Both databases were created with the same table creation scripts.  </p>
  
  <pre><code>"DELETE FROM [dbo].[tblMiddayMover] WITH (ROWLOCK)  WHERE [idMiddayMover] = @IdMiddayMover"
  </code></pre>
  
  <p>What reasons would this statement ever cause the database to hang.  </p>
  
  <p>After executing that statement, the following SELECT statement causes an error.</p>
  
  <pre><code>"SELECT * FROM [dbo].[tblMiddayMover] WHERE [fldActive] = 1"
  </code></pre>
  
  <p>I get the following error:</p>
  
  <p>Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.</p>
  
  <p>I can do select statements on any other table with no issues. </p>
  
  <p>I ran the command that was suggested, here is the output.
  <a href="http://softwaredesignexcellence.com/capture.PNG" rel="nofollow noreferrer">alt text http://softwaredesignexcellence.com/capture.PNG</a></p>