System information

,'RA MANAGER')
order by batch_duration desc
declare
@spid int
, @stmt_start int
, @stmt_end int
, @sql_handle binary(20)
set @spid = 124 -- Fill this in
select top 1
@sql_handle = sql_handle
, @stmt_start = case stmt_start when 0 then 0 else stmt_start / 2 end
, @stmt_end = case stmt_end when -1 then -1 else stmt_end / 2 end
from master.dbo.sysprocesses
where spid = @spid
order by ecid
SELECT
SUBSTRING( text,
COALESCE(NULLIF(@stmt_start, 0), 1),
CASE @stmt_end
WHEN -1
THEN DATALENGTH(text)
ELSE
(@stmt_end - @stmt_start)
END
)
FROM ::fn_get_sql(@sql_handle)
5.119. Load data from all tables from the database (for multiple servers)
The following query list all bind IP:
CREATE TABLE #tmp_333 (DatabaseName VARCHAR(50), valstr VARCHAR(64),keystr VARCHAR(50),inisection VARCHAR(50));
DECLARE DBCursor CURSOR
FOR
SELECT Name
FROM MASTER.dbo.sysdatabases
WHERE name NOT IN ('master','model','msdb','tempdb');