sp_lock2 is similar to sp_lock, except that it displays the database name, object name and index name instead of the ids. It accepts no parameters unlike the sp_lock procedure which can take an optional spid parameter. The basis for the main query which queries the system tables for lock info was taken from the sp_lock […]
2002-06-06
3,691 reads
By DataOnWheels
Hey folks, fun personal post today. A few weeks ago, I got married! My...
In June this year I took redundancy from the company I’d worked at for...
By Steve Jones
I posted that I was thinking about the AdventOfCode this year, but wasn’t sure...
I am trying to use the STUFF command, however, the column using the STUFF...
Hello, We had a few errors with replication for SQL Managed Instance stopped working...
I am trying to setup a linked server and per the documentation it needs...
Ask SSC