InstallAware

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.

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.

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.