>I would like to have a general function. Then I don't know the columns name.
>Marc, a few questions...
>
>1) You say you want to grab the last row that was inserted....are you sure you want "every" column, or just certain columns?
>
>2) A related question...are you doing this across several tables, or just for one table?
>
>
>As you've already read from other reponses, text and image columns won't work, unless you can somehow change the storage type without creating havoc in the application.
>
>By the way (though if you're stuck with SQL 2000, this won't help much), SQL 2008 implements Change Data Capture (CDC), which incorporates logging into the database manager, so it's all done automatically....reduced need for triggers.

I will have to read about CDC - thanks.

http://www.mssqltips.com/tip.asp?tip=1474