Log Example

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