When developing in SQLServer, it is often you may find someone has your record(s) locked and you can't get to them. By querying the system databases you can quickly find out who is blocking your progress using the following query to identify the process which you can then investigate on Task Manager on the server.
0 comments
Hide comments