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.