SQL Server Performance Forum – Threads Archive

storing results of a stored procedure

Is it possible to save the results of a stored procedure to a txt file?

http://www.sql-server-performance.com/tn_stored_procedure_returns.asp Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

If you do not pass any changing input parametres to stored procedure or if you have static stored proc to call..then you can also you SQL Jobs to get output automatically saved. create a sql job to call desired stored proc.. in the advance section of job step..give output file location.. using this you can schedule execution of your storeproc.
Deepak Kumar –An eye for an eye and everyone shall be blind

]]>