Penetration Testing mailing list archives
Re: Send output to file in SQL
From: "Narayana Kondreddi" <Vyaskn () btopenworld 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/
Current thread:
- Send output to file in SQL Alex Harasic (Mar 15)
- Re: Send output to file in SQL Kevin Spett (Mar 17)
- Re: Send output to file in SQL Narayana Kondreddi (Mar 17)
- <Possible follow-ups>
- RE: Send output to file in SQL Henry Dixon (Mar 17)
- RE: Send output to file in SQL Jonah Kowall (Mar 17)
- Re: Send output to file in SQL Alex S. Harasic (Mar 21)