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,464 reads
By Steve Jones
The PASS Data Community Summit is back in Seattle this November, the 14-17, 2023....
Information security and privacy are key in today’s data-driven world. Sensitive data needs to...
By SQLBalls
Hello Dear Reader! Sorry this is so late, moving houses has gotten me a...
Ok, need someone to talk me off the cursor ledge on this one. I...
Comments posted to this topic are about the item Better Communication Through Less Messaging
Comments posted to this topic are about the item MuleSoft Integration with Azure Key...
Ask SSC