How to get update source t-sql statement inside a trigger

• Atif

  Hall of Fame

  Points: 3578

  More actions

  July 20, 2009 at 2:50 am

  #155986

  How can i get the update T-SQL statement that causes update and provokes the trigger? I want to get the source T-SQL statement inside the trigger.

  Regards

  DBDigger Microsoft Data Platform Consultancy.

• spaghettidba

  SSC Guru

  Points: 105732

  More actions

  July 21, 2009 at 3:27 am

  #1027480

  You can use something like this:

  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 @SQLBuffer = EventInfo

  FROM @buffer

  Hope this helps

  Gianluca

  -- Gianluca Sartori