From: esquel@sommarskog.se   
      
   Peng Liu (liupengwyy@gmail.com) writes:   
   > According to your reply, do you mean that there might exist open   
   > transactions even the result of DBCC OPENTRAN indicates no active open   
   > transaction?   
      
   Yes, what DBCC OPENTRAN tells is that there is no uncommitted transaction   
   in the transaction log.   
      
   Or, in another words, DBCC OPENTRAN tells you that there no uncommitted   
   updates. But there might still be open transactions that hitherto only has   
   performed read operations (but which might hold locks, depending on the   
   isolation level.)   
      
   > From the step I list, can you find that there is still open transaction?   
   > from which step?   
      
   1 and 2.   
      
   > From the result of "select spid, lastwaittype, last_batch, status,   
   > open_tran, cmd, sql_handle from sys.sysprocesses where spid = 53;", the   
   > status value is sleeping, what does the "sleeping" mean?   
      
   The process is not running. It could be because it is awating a command   
   from the client, but it could also be waiting on I/O completion or a   
   locked resource to become available.   
      
   --   
   Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se   
      
   Books Online for SQL Server 2005 at   
   http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx   
   Books Online for SQL Server 2000 at   
   http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)