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

4.5 (2)

You rated this post out of 5. Change rating

2002-06-06

4,194 reads

Blogs

Advice I Like: Training Employees

By

Train employees well enough that they could get another job but treat them well...

Creating a Striped Backup Set with AI

By

I needed to test a striped backup, so I decided to ask the AI’s...

SQL Server Migration Overview

By

It’s Not Just Backup / Restore At some point every company faces it: the...

Read the latest Blogs

Forums

Create an HTML Report on the Status of SQL Server Agent Jobs

By Nisarg Upadhyay

Comments posted to this topic are about the item Create an HTML Report on...

hops from sql server to mysql to s4 hana - possible?

By stan

Hi when i think of server hops , i think of how kerberos assists...

Can/Can't Do/Don't

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Can/Can't Do/Don't

Visit the forum

Question of the Day

Strange String Splits

When I run this code, how many rows are returned?

DECLARE @meals NVARCHAR(1000) = N'夕食昼食朝食'
DECLARE @s NVARCHAR(1) = N'食'
SELECT value
FROM STRING_SPLIT(@meals, @s)
GO

See possible answers