How to do that?? Can anyone give me step by step procedure??
Tq
Srikanth
----- Original Message -----
From: "Ken Ambrose" <[Email Address Removed] "LazyDBA.com Discussion" <[Email Address Removed] 17 December, 2003 12:23 AM
Subject: RE: saving to txt ?
Call osql from the sp. It will save to text for you.
Ken
-----Original Message-----
From: Usman Farhat [mailto:Usman.[Email Address Removed] Tuesday, December 16, 2003 2:05 AM
To: LazyDBA.com Discussion
Subject: saving to txt ?
Hi Everyone,
Is there exist any command in sql server that saves result of an query
to text file. Same function that we perform in query analyser - query ->
result to file. Mine situation is to create a sp, that on call save
result set to an text file with name given.
Thanks,
Umsna
--------------------------------------------------------------------
NOTA CONFIDENZIALE:
Questo messaggio ed i suoi allegati sono indirizzati esclusivamente
alle persone indicate in testa e possono contenere informazioni
confidenziali. Se avete ricevuto il messaggio per sbaglio, sappiate
che qualunque utilizzo improprio del contenuto è proibito, Vi
preghiamo quindi di inoltrarlo immediatamente al mittente e di
cancellare il messaggio. Per qualsiasi informazione vi inivitiamo a
contattarci scrivendo a [Email Address Removed] NOTICE:
This message and its attachments are addressed solely to the
persons
above and may contain confidential information. If you have
received
the message in error, be informed that any use of the content
hereof
is prohibited. Please return it immediately to the sender and
delete
the message. Should you have any questions, please contact us by
replying
to [Email Address Removed] you
--------------------------------------------------------------------
---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
Get today's cartoon: http://www.LazyDBA.com
To unsubscribe, e-mail: mssqldba-[Email Address Removed] additional commands, e-mail: mssqldba-[Email Address Removed] REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
Get today's cartoon: http://www.LazyDBA.com
To unsubscribe, e-mail: mssqldba-[Email Address Removed] additional commands, e-mail: mssqldba-[Email Address Removed]MS Sql Server LazyDBA home page