Login or sign up Lost password?
Login or sign up
To obtain information about locks in the SQL Server Database Engine, use the sys.dm_tran_locks dynamic management view. 0 (success) The sp_lock result set contains one row for each lock held by the sessions specified in the @spid1 and @spid2 parameters. PAG: A number in the format fileid:pagenumber, where fileid identifies the file containing the page, and pagenumber identifies the page.