Write output to .sql file

[Speedy84]

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]

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]

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.