Home Forums SQL Server 2005 Backups SQL Server Database Engine cannot obtain a LOCK resource at this time RE: SQL Server Database Engine cannot obtain a LOCK resource at this time

  • I had a same error from SQL job in one step which is executing a stored procedure.

    And the reason was that at the same time index defragmentation and statstics update job was executing and it had a Schema-M lock on the table.