creatting a file using a stored procedure

[varocho]

Is there a way to create a file using a stored procedure?

 

[dickiebird]

In case you wondered if anyone was still out here -
No, as far as I know, there's no way to communicate with
the operating system from a stored procedure.
(At least I don't know one - someone gonna prove me wrong ?)
Cheers Dickie Bird (-)))

 

[grega]

Just a guess, but could you use xp_cmdshell ?

Greg.

 

[varocho]

Thanks to everyone for responding. Yes, using xp_cmdshell is an option, but I ended up having the stored procedure just write to standard output. Apparently the output can be redirected to a file by calling the isql program a certain way within a Unix script.

My next question: is there any way to suppress the

[return status = 0]

nessage that appears after the stored procedure stops running?