call bcp from stored procedure

Hi

How can I call the bcp from Stored procedure and generate text file ?


thank you in advance

Hi

You can run the bcp command through ESP xp_cmdshell.

For example, inside your stored proc, add the following sql command

exec xp_cmdshell 'bcp dbname..table out filename.bcp .....'


cheers
Joe


------------
mutley at 5/22/2002 11:50:20 AM


Hi

How can I call the bcp from Stored procedure and generate text file ?


thank you in advance