>Does anyone know if SQL Server can be programmed to create a text file from within a trigger or stored procedure. I searched BOL (ineptly probably) but a SQL equivalent to VFP's STRTOFILE() just didn't exist ;-) ...
>
>Thanks in advance,
>
>CT

Generally you would use DTS or Bulk Copy. I think you can start them both from an SP using xp_cmdshell.

I generally prefer doing exports from VFP. I have an SP that returns the data I need, and then COPY TO from VFP or I scan the table and build the layout I need.

BOb