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:

  • 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.

    Greetz
    Query Shepherd