Login | Register   
LinkedIn
Google+
Twitter
RSS Feed
Download our iPhone app
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX


Tip of the Day
Language: SQL Server
Expertise: Beginner
Oct 21, 1998

DBA

Question:
Other than specifying the "/o" option, is there a way to direct isql output to a file? I would like to specify the file name dynamically in a stored procedure.

Answer:
A stored procedure does not have access to the NT file system. (While you could use xp_cmdshell I would not recommend it.) If you need to control where your output is written to, I suggest you control it through a front-end application instead of looking to create that functionality in a stored procedure.

DevX Pro
 
Comment and Contribute

 

 

 

 

 


(Maximum characters: 1200). You have 1200 characters left.

 

 

Sitemap
Thanks for your registration, follow us on our social networks to keep up-to-date