You can also try using Dts to do the same.
Deepak

-----Original Message-----
From: Shibu MB [mailto:[Email Address Removed] Monday, November 25, 2002 10:46 PM
To: LazyDBA.com Discussion
Subject: RE: output to a text file..



Thanks a lot vijayakumar .......


Shibu



-----Original Message-----
From: VijayaKumar R S [mailto:[Email Address Removed] Tuesday, November 26, 2002 11:52 AM
To: Shibu MB
Cc: LazyDBA.com Discussion
Subject: Re: output to a text file..


Using BCP you can do this...dont forget to set the parameter to QUERYOUT

----- Original Message -----
From: "Shibu MB" <[Email Address Removed] "LazyDBA.com Discussion" <[Email Address Removed] Tuesday, November 26, 2002 11:30 AM
Subject: output to a text file..


Hi all

How can i write the output of a quey to text file ??? Is there any
utility
for that ??



Thanks
Shibu




---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To unsubscribe, e-mail: mssqldba-[Email Address Removed] additional commands, e-mail: mssqldba-[Email Address Removed]MS Sql Server LazyDBA home page