MSSQLTips

Under MSSQL 2000 I get a deadlock on a transaction. This victim transaction contains one single SELECT statement joining 2 tables using the READPAST hint. I thought this hint will cause the transaction not be blocked on locks. How can it happen that the transaction is part of a deadlock? The query looks...

Dear members, we provide a solution of bugs related to sql server along with study material and interview preparation of SQL server. click below link to get your solution http://mssqlinterview.blogspot.com/

Hi, MSSQL2000 has such a feature that it detects deadlocks and kills one of the transactions which take part in the deadlock. I would like to turn off this feature (for debugging purposes), i.e. make the server not to terminate these transactions (i.e. block forever). Is there a flag/setting in the DB...