SELECT req.start_time
, '1'
, SUBSTRING(t.text, req.statement_start_offset, CASE WHEN req.statement_end_offset > 0 THEN req.statement_end_offset - req.statement_start_offset ELSE LEN(t.text)-req.statement_start_offset END)
FROM sys.dm_exec_requests req
CROSS APPLY sys.dm_exec_sql_text(req.sql_handle) t
WHERE req.session_id = @@SPID;
SELECT c1.*
INTO #t
FROM syscolumns c1, syscolumns c2;
SELECT req.start_time
, '2'
, SUBSTRING(t.text, req.statement_start_offset, CASE WHEN req.statement_end_offset > 0 THEN req.statement_end_offset - req.statement_start_offset ELSE LEN(t.text)-req.statem…