第25個冬天

  在朝狀交易特別是層層包覆的SP十分容易遇到.... 建議先不要特別為transaction 取名 一律都統一用 begin tran commit tran rollback tran https://stackoverflow.com/questions/19260055/cannot-roll-back-subtransaction-no-transaction-or-savepoint-of-that-name-was-fo https://www.sqlservercentral.com/forums/topic/transaction-no-transaction-or-savepoint-of-that-name-was-found https://blog.sqlauthority.com/2015/03/11/sql-server-error-msg-6401-level-16-cannot-roll-back-transaction/

  SELECT request_session_id AS spid,     resource_type AS rt,     resource_databASe_id AS rdb,     (CASE resource_type      WHEN 'OBJECT' then object_name(resource_ASsociated_entity_id)      WHEN 'DATABASE' then 'sombas'      ELSE      (SELECT object_name(object_id) FROM sys.partitions          WHERE hobt_id = resource_ASsociated_entity_id) END) AS objname,     resource_description AS rd,     request_mode AS rm,     request_status AS rs FROM sys.dm_tran_locks where request_mode IN ('X','IX') --X 表示 dead lock --IX 表示 wait lock ，這種是因為前一個Request已經dead lock，而被pending的狀態。 kill {上一個查詢結果集的 spid} SELECT * FROM sys.dm_tran_locks WHERE resource_database_id = DB_ID()  AND resource_associated_entity_id = OBJECT_ID(N'dbo.Table名'); select cmd,* from sys.sysprocesses where blocked > 0         SELECT r.session_id,   ...