Schedule stored procedure and save output to network drive

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?

    Requires Free Membership to View

    Login

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

Join the conversationComment

Share
Comments

    Results

    Contribute to the conversation

    All fields are required. Comments will appear at the bottom of the article.
    Back to top