|
Posted by reddy via SQLMonster.com on 10/01/29 11:17
Hi Dan
I Created deadlock and opened new page and typed the command
DBCC TRACEON (1205,3605,-1).
I didn't see any deadlock message except
(End deadlock search 9232 a deadlock was not found)
but in enterprise manager showing spid 54 blocking and spid 55 blocked.
even tried (1204).
Can you please tell step by step how to see locking.
i am using standard vresion
Thanks
--
Message posted via http://www.sqlmonster.com
Navigation:
[Reply to this message]
|