Home Forums SQL Server 2008 SQL Server 2008 Administration The instance of the SQL Server Database Engine cannot obtain a LOCK resource at this time. Rerun your statement when there are fewer active users. Ask the database administrator to check the lock and memory configuration for this instance, or to check for long-running transactions. RE: The instance of the SQL Server Database Engine cannot obtain a LOCK resource at this time. Rerun your statement when there are fewer active users. Ask the database administrator to check the lock and memory configuration for this instance, or to check for long-running transactions.

  • May 15, 2013 at 8:43 am

    #1615458

    I don't mean this rudely but the text of the error message gives you quite a lot to be going on with, there. Are there any long-running transactions that might be preventing the lock?

    Also not meant rudely, but I'd Google that error message if I were you. Perhaps the problem has resolved itself by now though :-).