>>>You can now do this...
>>>
>>>

INSERT INTO MyTable (ColumnList) output inserted.*  VALUES (@ColumnList)

>>
>>
>>Neat stuff Kevin ...
>
>There was a nice thread about it in tek-tips site recently, but I could not find it at the moment and put a bookmark at home computer...

Here it is
http://sqlservercode.blogspot.com/2006/10/hello-output-see-you-later-trigger-or.html