Tuesday, March 27, 2012

export DB into a flat text file "notepad"

what is the best way to go about this?
using MS SQL 2000
on W2K server
thanks
antz
"Antz" <anonymous@.discussions.microsoft.com> wrote in message
news:1a8901c426f8$be06d440$a101280a@.phx.gbl...
> what is the best way to go about this?
> using MS SQL 2000
> on W2K server
Use DTS (Data Transformation services) to export your tables to text format.
Or, even more primitive ;) BCP will also work.
Steve

No comments:

Post a Comment