8. SQL Statements : SET : [No]Lock_Trace
The SET LOCK_TRACE statement enables the display of locking activity for the current session, including information about the locks taken and locks released. Lock tracing can be started or stopped at any time during a session. For details on the usage and output of this statement, see the Database Administrator Guide.
Important!  Use SET LOCK_TRACE as a debugging or tracing tool only. LOCK_TRACE is not a supported feature, which means that the format and layout of the output can be changed without prior notification.