SQL Guy 1
SSCoach
Points: 15786
More actions
February 4, 2021 at 7:25 pm
#3841125
Hi all,
I am testing my data purging (deleting) procedure, and while it's running I monitor sys.dm_tran_locks. It shows everything for every lock, but not a scope (like row or page). Or maybe I should check in another DMV?
Thanks
Jeff Moden
SSC Guru
Points: 1000539
February 4, 2021 at 11:27 pm
#3841188
Although it's been deprecated, it's still available. Try sp_Lock.
--Jeff Moden
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply