Posted by John Bell on 05/28/05 22:19
Hi
Have you looked at:
http://support.microsoft.com/kb/271509/EN-US/
Also "Inside SQL Server 2000" by Kalen Delany ISBN
0-7356-0998-5 is a good source for understanding and resolving blocking.
John
"pardhi via SQLMonster.com" <forum@nospam.SQLMonster.com> wrote in message
news:5cc8e2b282894cce84e1ab206f439136@SQLMonster.com...
> Hi Everybody
>
> I am new to sqlserver 2000.I know basics of locks.but i dont know how to
> resolve deadlock issues.I am cofusing by reading articles with 90%
> information and remaining 10% missing.Can any one help me which is the
> good
> site to learn and resolve deadlocks.
>
> Note: I create deadlock. when i try to trace deadlock using dbcc traceon
> (1205,3604,-1).In error log showing nothing about the deadlock.
>
> showing created traceon.........
>
> Any help would be appreciated.
>
> --
> Message posted via http://www.sqlmonster.com
Navigation:
[Reply to this message]
|