Look at the bcp.exe application. It'll do what you want, but you'll
need to write some form of wrapper for it to 'backup' all tables...

-----Original Message-----
From: Sanjay
[mailto:mssqldba-ezmlmshield-x64896500.[Email address protected]
Sent: Wednesday, January 31, 2007 1:25 PM
To: LazyDBA Discussion
Subject: Backup



-----Original Message-----
I want to take backup of my all the tables in .TXT format with column
name.
Can any one give any script to do this job?

Sanjay

_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
_ _


Confidentiality Notice

The information contained in this electronic message and any attachments
to this message are intended for the exclusive use of the addressee(s)
and may contain confidential or privileged information. If you are not
the intended recipient, please notify the sender at Hinduja TMT Ltd or
[Email address protected] immediately and destroy all copies of this
message and any attachments.



---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY To post a
dba job: http://jobs.lazydba.com To subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html



------------------------------------------------------------------------------
NOTICE OF CONFIDENTIALITY
The information contained in this communication and any accompanying document(s) is proprietary and confidential and is intended solely for the above-named individual or entity. If you are not the intended receiver, recipient or entity, you are advised that any distribution, copying, disclosure or communication of this email is strictly prohibited. If you have received this email in error, please contact me at the telephone number listed above or 858.716.1500.
==============================================================================


MS Sql Server LazyDBA home page