Technical Article

sp_lock2  = sp_lock +shows database and object name

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 […]

(2)

You rated this post out of 5. Change rating

2002-06-06

4,213 reads

Blogs

The Book of Redgate: What Our Staff Says

By

This image is from 2010, and it goes along with my last post of...

PASS Keynote Shots

By

Rodney Kidd took some great shots of the keynote and published an album here:...

Microsoft AI Red Teaming Course

By

here is the compiled video of the Red Teaming course Microsoft put together.

Read the latest Blogs

Forums

Fabric Mirroring

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Fabric Mirroring

T-SQL in SQL Server 2025: The UNISTR Function

By Steve Jones - SSC Editor

Comments posted to this topic are about the item T-SQL in SQL Server 2025:...

How Important Are Real Time Decisions?

By Steve Jones - SSC Editor

Comments posted to this topic are about the item How Important Are Real Time...

Visit the forum

Question of the Day

Fabric Mirroring

In which versions can I mirror a database from an on-premises SQL Server to a Fabric data warehouse?

See possible answers