Q

Schedule stored procedure and save output to network drive

Find how to save stored procedure output to the network drive via SQL Server Management Studio.

Is it possible to schedule a stored procedure to run in SQL Server and save the output as a text file on the network drive?
Proc output is sent to a client application. You can save the stored procedure output from a query window in SQL Server Management Studio to a file on a network drive. Alternately, you can write a SQL CLR stored procedure to output to a file.
This was first published in December 2007

Dig deeper on SQL Server Stored Procedures

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

SearchBusinessAnalytics

SearchDataCenter

SearchDataManagement

SearchAWS

SearchOracle

SearchContentManagement

SearchWindowsServer

Close