Write output to .sql file

Speedy84 · Post by **Speedy84** » Tue Jul 03, 2007 8:45 am

Is there a possibility to write the script output to an .sql file.

I need this to make a schedule task in windows to be executed and call a stored procedure to backup my SQL Express 2005 database.

But i can only write the output to an .txt file or an .ini file.

Edhy · Post by **Edhy** » Tue Jul 03, 2007 9:01 am

Hi,

I really don't know the answer to this, but maybe you could simply rename the resulting .txt file to .sql when the process is done.

jimo · Post by **jimo** » Tue Jul 03, 2007 4:25 pm

The write to text file command will write to any fielname, I do this all the time. The file does not have to have a txt extension in can have a sql extension, it's still a text file.