Monitoring Lock Activity in SQL Server :: Chapter 38. Locking and Performance :: Part V: SQL Server Internals and Performance Tuning :: Microsoft SQL Server 2000 :: SQL :: eTutorials.org
Remote Query Timeout Option – Common SQL Server Misconception » SQLGeeksPro
SQL Server lock issues when using a DDL (including SELECT INTO) clause in long running transactions