how to use bcp command to output stored procedure result



Hello all

I can use bcp command to output database views to text file. My
statement is:
bcp database_name..viewname out output_filename.txt -Uusername
-Sservername -Ppassword -c

However, an error occurs when I use the same statment to output stored
procedure result. I typed:
bcp database_name..stored_procedure_name out output_filename.txt
-Uusername -Sservername -Ppassword -c

Could anyone give me some suggestions?

Thanks

BJ

.