SQL Server Performance Forum – Threads Archive

Output of a query into a file

Hi, In a stored procedure how do I output the result of a query to a text file? Regards, Bharathram G

---

Look for bcp in SQL Server help file Madhivanan Failing to plan is Planning to fail

---

http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=6999
http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=8478

---

Hi,
bcp with cmdshell does not work for me. Is there any other way?
Bharathram

---

what problem are you facing

---

Post the query you used Madhivanan Failing to plan is Planning to fail

---

]]>