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
Jeganathan.M
SSC Rookie
Points: 41
More actions
September 19, 2012 at 12:19 am
#1539391
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.