| Author: Anand Keshav 05 May 2008 | Member Level: Bronze Points : 2 |
From above code things are not clear.it should be in proper manner.
|
| Author: andy robarts 05 May 2008 | Member Level: Gold Points : 2 |
USE MASTER
GO
CREATE PROCEDURE [dbo].[sp_LockDetail]
AS
BEGIN
SELECT
SessionID = s.Session_id,
resource_type,
DatabaseName = DB_NAME(resource_database_id),
request_mode,
request_type,
login_time,
host_name,
program_name,
client_interface_name,
login_name,
nt_domain,
nt_user_name,
s.status,
last_request_start_time,
last_request_end_time,
s.logical_reads,
s.reads,
request_status,
request_owner_type,
objectid,
dbid,
a.number,
a.encrypted ,
a.blocking_session_id,
a.text
FROM
sys.dm_tran_locks l
JOIN sys.dm_exec_sessions s ON l.request_session_id = s.session_id
LEFT JOIN
(
SELECT *
FROM sys.dm_exec_requests r
CROSS APPLY
sys.dm_exec_sql_text(sql_handle)
) a ON s.session_id = a.session_id
WHERE
s.session_id > 50
EN
|
| Author: venkat kamal 05 May 2008 | Member Level: Gold Points : 2 |
hey its not clear, so give clear information.........
|