Create file using Stored Procedure

I there a way to create a text file from within a stored procedure ?Not directly using T-SQL, but you could use DTS or BCP. See Books Online for
more info. Also check this link: http://vyaskn.tripod.com/code.htm#txtfile
--
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"Rob C" <rwc1960@.bellsouth.net> wrote in message
news:u4oRd.667$a96.420@.bignews3.bellsouth.net...
I there a way to create a text file from within a stored procedure ?|||XP_cmdshell and OSQL work great. I just completed a project to do just that.
Hello Rob,

> I there a way to create a text file from within a stored procedure ?
>