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.
Charlie has over a decade of experience in website administration and technology management. As the site admin, he oversees all technical aspects of running a high-traffic online platform, ensuring optimal performance, security, and user experience.
