Re: Send output to file in SQL

From: Alex S. Harasic (aharasic@terra.cl)
Date: 03/21/02 

From: "Alex S. Harasic" <aharasic@terra.cl>
To: "Jonah Kowall" <jkowall@psteering.com>, <pen-test@securityfocus.com>
Date: Thu, 21 Mar 2002 08:31:24 -0400

Actually, the main idea of my posting was to create a file using sql
commands but as a SQL Injection thing. But it seems to be that the only way
to go is using either xp_cmdshell or makewebtasks extended procedures...

Alex S. Harasic
aharasic@terra.cl

----- Original Message -----
From: "Jonah Kowall" <jkowall@psteering.com>
To: "Alex Harasic" <aharasic@terra.cl>; <pen-test@securityfocus.com>
Sent: Friday, March 15, 2002 2:36 PM
Subject: RE: Send output to file in SQL

Are you running mssql 2000 or an earlier version? If you are running
2k, then you may be able to use the sp_makewebtask stored procedure.

Or you can run isql from the command line:

If you want the output to a .txt file just use isql at a cmd prompt
(%MSSQLPATH%\binn\isql > c:\mssql\binn\isql) with the parameter -o for
outputfile and use -q for the query or -i for inputfile (if you got
several statements).

c:\mssql\binn\isql -Usa -P -ddb1 -Sserv1 -i in.sql -o out.txt
where: -Usa > user, -P > password, -ddb1 > your database, -i in.sql >
your input file, -o out.txt > your output file.

> -----Original Message-----
> From: Alex Harasic [mailto:aharasic@terra.cl]
> Sent: Wednesday, March 13, 2002 12:05 PM
> To: pen-test@securityfocus.com
> 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
>
> aharasic@terra.cl
>
> --------------------------------------------------------------
> --------------
> 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/

----------------------------------------------------------------------------
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/

Relevant Pages

  • RE: SQL
    ... Subject: SQL ... statement being executed in the ISS server ... > This list is provided by the SecurityFocus Security ... For more information on SecurityFocus' SIA service which ...
    (Pen-Test)
  • Re: SQL
    ... Subject: SQL ... SELECT * FROM tblUsers WHERE Username='admin'; ... > This list is provided by the SecurityFocus Security Intelligence Alert ... For more information on SecurityFocus' SIA service which ...
    (Pen-Test)
  • RE: MS Office Files
    ... You are trying to trace back to a particular machine I ... > This list is provided by the SecurityFocus Security ... > Intelligence Alert Service. ... > SecurityFocus' SIA service which automatically alerts you to ...
    (Pen-Test)
  • RE: SQL
    ... I'm not all that knowledgeable about SQL testing.. ... > This list is provided by the SecurityFocus Security ... For more information on SecurityFocus' SIA service which ... This list is provided by the SecurityFocus Security Intelligence Alert ...
    (Pen-Test)
  • RE: Laboratory Setup Help (RS)
    ... >> This list is provided by the SecurityFocus Security ... For more information on SecurityFocus' SIA service which ... >> vulnerabilities please see: ... >This list is provided by the SecurityFocus Security Intelligence Alert ...
    (Pen-Test)