DBCC INPUTBUFFER returns the proc being used, with parameters and full path, vs. the DMV's return the definition of the procedure being created.

This is the trigger i am using to get the insert/update/delete Statements from InputBuffer

ALTER TRIGGER [dbo].[StudentTrigger]

ON [dbo].[Students]

AFTER Insert, UPDATE, DELETE

AS

Declare @SqlStatement Nvarchar(Max)

CREATE TABLE SQLLog (

language_event NVARCHAR(100),

parameters INT,

event_info...