Hi Sanjay,
You can try bcp out with the following syntax.
bcp master..syslogins out syslogins.txt -Usa -S DB_NAME -c -t!
Rgds,
Mudit
-----Original Message-----
From: Sanjay
[mailto:mssqldba-ezmlmshield-x64896500.[Email address protected]
Sent: Thursday, February 01, 2007 8:25 AM
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
_______________________________________________________________________
This E-Mail (including any attachments) may contain privileged or confidential information. It is intended only for the addressee(s) indicated above.
The sender does not waive any of its rights, privileges or other protections respecting this information.
Any distribution, copying or other use of this E-Mail or the information it contains, by other than an intended recipient, is not sanctioned and is prohibited.
If you received this E-Mail in error, please delete it and advise the sender (by return E-Mail or otherwise) immediately.
This E-Mail (including any attachments) has been scanned for viruses.
It is believed to be free of any virus or other defect that might affect any computer system into which it is received and opened.
However, it is the responsibility of the recipient to ensure that it is virus free.
The sender accepts no responsibility for any loss or damage arising in any way from its use.
E-Mail received by or sent from RBC Capital Markets is subject to review by Supervisory personnel.
Such communications are retained and may be produced to regulatory authorities or others with legal rights to the information.
MS Sql Server LazyDBA home page