Re: Send output to file in SQL

From: Narayana Kondreddi (Vyaskn@btopenworld.com)
Date: 03/15/02 

From: "Narayana Kondreddi" <Vyaskn@btopenworld.com>
To: "Alex Harasic" <aharasic@terra.cl>, <pen-test@securityfocus.com>
Date: Fri, 15 Mar 2002 20:48:09 -0000

Alec, there are couple of ways to do this in Microsoft SQL Server.

 - Use a DTS (Data Transformation Services) package to output the query
results to a text file (SQL Server 7.0 and above)
 - Run the query from command line, using isql.exe or osql.exe by passing
the query and the output file name as parameters
 - In Query Analyzer, you can save the output to a file, from the File menu

HTH,
Vyas, MVP (SQL Server)
Check out my SQL Server website @
http://vyaskn.tripod.com/

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

Relevant Pages

  • Re: SQL Injection
    ... > To my knowledge I can do this in SQL by separating the two queries with; however this is no happening in my case in two circumstances... ... > I have a discovered an injectable sql query that is fed its data from a web form, the end query build by a cgi-script being ... > This list is provided by the SecurityFocus Security Intelligence Alert ... For more information on SecurityFocus' SIA service which ...
    (Pen-Test)
  • RE: SQL Injection
    ... > I have a discovered an injectable sql query that is fed its data from a web form, the end query build by a cgi-script being ... > This list is provided by the SecurityFocus Security Intelligence Alert ... For more information on SecurityFocus' SIA service which ...
    (Pen-Test)
  • hacking a NT domain after the member server
    ... Currently doing a penetration test and managed to compromise a development ... SQL server that is a member of the domain. ... This list is provided by the SecurityFocus Security Intelligence Alert ... For more information on SecurityFocus' SIA service which ...
    (Pen-Test)
  • SQL Insertion
    ... [ODBC SQL Server Driver][SQL ... This list is provided by the SecurityFocus Security Intelligence Alert ... For more information on SecurityFocus' SIA service which ...
    (Pen-Test)
  • RE: SQL
    ... statement being executed in the ISS server ... which will run the 'dir' command in the SQL server ... > This list is provided by the SecurityFocus Security ... For more information on SecurityFocus' SIA service which ...
    (Pen-Test)