Home Forums SQL Server 2005 Administering Locks from inactive spid???? RE: Locks from inactive spid????
Michael Earl-395764
SSC Guru
Points: 53873
More actions
August 6, 2008 at 7:36 am
#853809
Were the cursors related to the locked records? That would be the first place to look. Is it an updatable cursor? If it is and does not need to be, perhaps just using the READONLY keyword will solve your issue (you will not get exclusive locks).