export data from Microsoft SQL Server 2000 into text file

bcp is the command line utility to export data from sql2000.
here’s an example how to export by select query:
bcp “select * from log” queryout log.txt -c -Uusername -Ppassword -Sservername

Leave a Comment

You must be logged in to post a comment.