How to view data in "inserted" table ???

[CInman]

Is it possible, during an insert trigger, to somehow view the contents of the "temporary" "inserted" table? I am trying to debug a trigger, and need to see the actual contents of the "inserted" table to do so ... is there a trick for this as the MS documentation never mentions it anywhere?

 

[fluteplr]

you could change the trigger to insert the data into a copy of the table.

as in.

insert into duptable select * from inserted

it won't let you look while the trigger is running but at least you could see what was there at the time.