Home Forums SQL Server 2008 SQL Server 2008 Administration Cannot obtain LOCK resource at this time :sick: RE: Cannot obtain LOCK resource at this time :sick:
Query Shepherd
SSCrazy
Points: 2988
More actions
February 6, 2013 at 6:54 am
#1584931
Have you got any of the lock escalation traceflags turned on?
Nope...
Are you using any locking hints?
Got snapshot isolation mode activated. The developers use NOLOCK AND ROWLOCK.
GreetzQuery Shepherd