QUESTION POSED ON: 06 December 2007 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?
>
EXPERT RESPONSE
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.
Search and Browse the Expert Answer Center Search and browse more than 25,000 question and
answer pairs from more than 250 TechTarget industry experts.
TechTarget provides enterprise IT professionals with the information they need to perform their jobs - from developing strategy, to making cost-effective IT purchase decisions and managing their organizations' IT projects - with its network of technology-specific Web sites, events and magazines.
