Writing a text file from SQL Server 7

[waggers]

I am trying to run an automated job from SQL Server that will run a number of stored procedures and then create a static HTML file based on the results.
Does anybody know how to write to a text file from SQL Server - I am aware that this can be done using ActiveX scripts but how do I get one of these to execute?
I would prefer to do all this from a stored procedure as I could then include this in the automatic overnight processing.
TIA
Tom Waghorn

 

[ColinM]

You could use xp_cmdshell with bcp.
Or you could schedule a DTS package.

You might also have a look at the web assisant wizard, which may be able to do what you looking for. [sig][/sig]

 

[BootMeUp]

Use the Web Wizard to create your HTML page. It will let you select stored procedure(s) and run when you want. I've used it and it works well. [sig][/sig]