Database troubleshooting is not for the faint of heart, especially when it comes to troubleshooting locking and blocking problems. Sometimes the elephant in the room is actually a rhino, a problem ...

Hi folks,<br><br>Me again. Let's say you have a SQL Server 2000 DB with no locking enabled. And then let's say that you want to enable locking, even very rudimentary ...

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