Mircosoft SQL Server online docs home page, for current version (2008 R2) as well as our 2005 version. Links to "Books Online", "Compact Edition", and White Papers in three editions.
"This article looks at the basics of locking features in SQL Server 2008, and peeks into the inner workings to learn how SQL Server implements locking."