Skip to content
John Huang's Blog

John Huang's Blog

About SQL Server, Schema z, and Others

  • Schema Z
  • About…

Month: December 2011

sp_rename Causes Lock Leaking

February 4, 2012December 2, 2011 by John H

One of my friends finds this issue in the systems he is managing. In my locking and blocking series, I mentioned that when a record is being modified it always acquires IX lock on the object, IX lock on the page, and X lock on the record. In rare case, this may also hold IX lock on another object. This is cased by sp_rename.

Read more

Categories Locking and Blocking, Miscellaneous Tags Locking and Blocking 2 Comments
Newer posts
← Previous Page1 Page2
© 2026 John Huang's Blog • Built with GeneratePress