Dear Sir , your wrote: " I'd either use bcp to output to a temporary file and then concatenate the two together".

Please tell me that how would this be implemented.

I want that when i insert a record in a table in sql then a trigger is fired on the insert , which executes a stored procedure , the procedure appends the new record into a text file in my C drive.