if exists(select 1 from inserted where OrderNo=27283 and Host=33) begin
declare @t varchar(max)
declare @ExecStr varchar(50), @Qry nvarchar(4000)
CREATE TABLE #inputbuffer
(
EventType nvarchar(30),
Parameters int,
EventInfo nvarchar(4000)
)
SET @ExecStr = 'DBCC INPUTBUFFER(' + STR(@@SPID) + ') WITH NO_INFOMSGS'
INSERT INTO #inputbuffer
EXEC (@ExecStr)
SET @Qry = (SELECT EventInfo FROM #inputbuffer)
insert stat..table_log(PostTime,SPID,ServerName,LoginName,UserName,Host,Program,DatabaseName,SqlText,t_id,tname)
select
getdate(),
@@spid,
@@servername,
suser_name(),
user_name(),
host_name(),
master.dbo.ifjob(app_name()),
db_name(),
@Qry,
(select top 1 OrderNo from inserted),
'OrderNo'
drop table #inputbuffer
end
Comments
0 B
|👍
/👎
0 B
|👍
/👎