how to make a text file

I have a table(tblUser) on SQL Server. I like to create a text file somewhere on the SQL Server after a new record is inserted into the table(tblUser). The content of the text file should be the new record. Is there any way to do that?

Thanks!

Regards,

Kevin Jinyou could have a trigger which fires off a script with xp_cmdshell, but that's probably not quite ideal..