SQL Server 死锁检查

      
        
          select
        
        
           spid, blocked, status, hostname, program_name, hostprocess, cmd 
          

        
        
          from
        
        
           sysprocesses 
        
        
          where
        
         dbid 
        
          =
        
        
          db_id
        
        (
        
          'xxx
        
        
          '
        
        
          ) 
        
        
          and
        
         blocked 
        
          > 
        
        
          0
        
        
          --
        
        
           kill spid_xxx