Get the running queries:
select r.session_id,r.status,r.start_time,r.total_elapsed_time,r.command,s.text
from sys.dm_exec_requests r
cross apply sys.dm_exec_sql_text(r.sql_handle) s
--where r.status='running'
Get linked servers:
exec sp_linkedservers
No comments:
Post a Comment