Stored procedure output to a file

[Dan Collins]

How do I direct output from a stored procedure to a file? I am using the Print
statement that prints output to the Query Analyzer screen. I do I direct
Print statements to a test file?
Thanks,
Dan Collins

[Paul Mc]

G'day Dan.

The Print statement in TSQL is not what it sounds like - basically it similar
to Debug.Print in VB except that it is not left out at compile time...

As for directing output to a file, that depends on the circumstances:

A) What is the situation - are you running the SP from the query analyser
or via ADO from a client app etc...

B) Where do you want the file - ie do you want the server to output it to
a file one the server, or the client to control the writing of the file?

C) What format do you want? ie Text, HTML, XML?

If you detail the situation further I am sure we could help you out...

Cheeers,
Paul