inside the trigger, you can capture the first 4000 chars of the command text:

inside a trigger, you can do this, (DBCC INPUTUFFER can be used by users agasint their own spid)

--################################################################################################

--because dbcc inputbuffer is limited to 4000 chars, you may need to combine this witha DML trace

--################################################################################################

DECLARE @SQLBuffer nvarchar(4000)

DECLARE @buffer TABLE (

EventType nvarchar(30),

Parameters int,

EventInfo nvarchar(4000)

)

INSERT @buffer

EXEC sp_executesql N'DBCC INPUTBUFFER(@@spid) WITH NO_INFOMSGS'

SELECT @LASTCOMMAND = EventInfo

FROM @buffer