Home Forums SQL Server 2014 Administration - SQL Server 2014 storedprocedure to run a sql file(abc.sql) and store result in a file(abc.txt) RE: storedprocedure to run a sql file(abc.sql) and store result in a file(abc.txt)
Steve Jones - SSC Editor
SSC Guru
Points: 734552
More actions
February 5, 2016 at 2:53 pm
#1856966
Yep, Jeff is right that you can use redirection from a command line.
If you need to do this inside SQL Server, you can use xp_cmdshell to call this in a shell.