is there any good documentation about the locks, since i just started to working on locks i need to know more information, locks, types , esculation thanks
Start with Books online for sQL 2005. My blog -http://sqlserver-qa.net/blogs/tools...rrency-locking-with-asp-net-applications.aspx Satya SKJ Microsoft SQL Server MVP Writer, Contributing Editor & Moderator http://www.SQL-Server-Performance.Com This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.
Check the following from BOL and SQL Server Storage Engine Blog... SQL Server 2005 Books Online Lock Compatibility http://msdn2.microsoft.com/en-us/library/ms186396.aspx Locking in the Database Engine http://msdn2.microsoft.com/en-us/library/ms190615.aspx Lock Escalation (Database Engine http://msdn2.microsoft.com/en-us/library/ms184286.aspx http://blogs.msdn.com/sqlserverstorageengine/archive/2006/05/17/600132.aspx MohammedU. Moderator SQL-Server-Performance.com All postings are provided “AS IS†with no warranties for accuracy.
