SQLism
Logging and Blogging SQL Server Experiences.
Showing posts with label
specific
.
Show all posts
Showing posts with label
specific
.
Show all posts
Monday, February 27, 2017
Find what script is being run by specific SPID number
DECLARE @sqltext VARBINARY(128)
SELECT @sqltext = sql_handle
FROM sys.sysprocesses
WHERE spid = 53
SELECT TEXT
FROM sys.dm_exec_sql_text(@sqltext)
GO
Older Posts
Home
Subscribe to:
Posts (Atom)