Use scripting shorthand to simplify your code

I recently faced a vexing problem when I migrated a web application to VS.NET 2003. Googling this issue generated any similar hits with some recommendations one of which worked but was tedious...

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