In this post we are going to see how to find the script for the running process in sql server.
Replace the spid with the process id of the instance, how to get the spid click this link
From this post you are going to learn how to find the script for the running process in sql server.
Replace the spid with the process id of the instance, how to get the spid click this link
DECLARE @sqltext VARBINARY(128)
SELECT @sqltext = sql_handle
FROM sys.sysprocesses
WHERE spid = 1
SELECT TEXT
FROM sys.dm_exec_sql_text(@sqltext)
GO
From this post you are going to learn how to find the script for the running process in sql server.
Very good and detailed article.
ReplyDeleteDot Net Training with Placements
Thank you for every other informative web site. Where else may I am getting that kind of information written in such a perfect way? I’ve a undertaking that I’m just now working on, and I have been on the look out for such information.
ReplyDeleteUOK BCom Result
UOK BCom 1st Year Result
UOK BCom 2nd Year Result
UOK BCom 3rd Year Result
Awesome blog, thank you so much for sharing such an amazing information with us. Visit Import Globals for Vietnam Import and Export Data Services at Vietnam customs.
ReplyDeleteVietnam Export Data