You'd have to write this as an Insert Trigger and there is no general dump command. You'll have to concat. the column values together yourself.

Also, a SQL Server trigger fires one no matter how many rows are affected by the DML. This means that your trigger will have to be able to handle multiple rows.

You'll probably have better performance writing it to a table instead of a file.

-Mike

>Humm ... let's start this all over again.
>
>Is there anyway to dump the contents of a SQL Server table (one row all columns) into a text file each time a new row is added?
>
>CT