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