Hi Friends
I want to know about the Lock Escalation used SQL sever and how does it use ?
Loading
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Jignesh TrivediPosted Aug 29, 2012, 9:02 AM
Please refer...
http://msdn.microsoft.com/en-us/library/ms184286%28v=sql.105%29.aspx
http://sqlserverpedia.com/blog/sql-server-bloggers/table-partitioning-and-lock_escalation-in-sql-server-2008-2/
hope this will help you.