generating text file

I have a table(say tblUserInfo) on SQL Server. What I like to do is a text file will be generated on the hard drive which SQL Server sits on when a new record is inserted into tblUserInfo. The content of the text file comes from the table. Is there any way we can go for doing that?I'm not 100% clear on what you want to do here, but it seems to me what you want to do could be achieved with a trigger which does a callout to a COM object which then manipulates the text file. this is an off-the-top-of-the-head solution and there may be a better way, but that would require me hitting the book and it's too early in the morning here for that!|||The help you gave me was much appreciated. Could you please let me know more detail about that when you have a chance?

Regards,

Kevin Jin