MSSQLTips

I am facing a problem in MSSQL: - I have a table in MSSQL, which has 10 rows & 5 columns. In this table I am maintaining a numeric range in 2 columns. First one has starting number & second column has end number. All rows have unique values in these 2 columns. For Ex.: - In first row the value...

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...