forked from cjfaulkner/SQL
-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathOpenRowSetTrick.sql
More file actions
23 lines (22 loc) · 860 Bytes
/
OpenRowSetTrick.sql
File metadata and controls
23 lines (22 loc) · 860 Bytes
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
SELECT who.loginame AS LoginName,
who.HostName,
DB_NAME(locks.dbid) AS DatabaseName,
who.SPID,
locks.Type
FROM OPENROWSET ('SQLOLEDB','Server=(local);TRUSTED_CONNECTION=YES;','set fmtonly off exec master.dbo.sp_who')
AS who
JOIN OPENROWSET ('SQLOLEDB','Server=(local);TRUSTED_CONNECTION=YES;','set fmtonly off exec master.dbo.sp_lock')
AS locks
ON who.spid = locks.spid
--EXEC(@SQL) AT .......
SELECT who.loginame AS LoginName,
who.HostName,
DB_NAME(locks.dbid) AS DatabaseName,
who.SPID,
locks.Type
FROM OPENROWSET ('SQLCLI','Server=(local);TRUSTED_CONNECTION=YES;','set fmtonly off exec master.dbo.sp_who')
AS who
JOIN OPENROWSET ('SQLCLI','Server=(local);TRUSTED_CONNECTION=YES;','set fmtonly off exec master.dbo.sp_lock')
AS locks
ON who.spid = locks.spid
--EXEC(@SQL) AT .......