Explanation:sp_lock reports information about locks.use the sys.dm_tran_locks dynamic management view in future versions. 10. The Activity Monitor in SQL Server Management Studio graphically displays information about :
A. User activity.
B. Blocked processes.
C. Locks
D. All of the mentioned
Answer:A
Explanation:sp_lock reports information about locks.use the sys.dm_tran_locks dynamic management view in future versions. 10. The Activity Monitor in SQL Server Management Studio graphically displays information about :
A. User activity. B. Blocked processes. C. Locks D. All of the mentioned
Explanation:This parameters are useful for ad hoc views of current activity. Sanfoundry Global Education & Learning Series – SQL Server.