how can i download a plain text , csv, etc version of my SQL 2005 database?

[wisemx]

I think you'll need to write a code page to do it.
Which is a standard practice on remote servers.

Another method, which I've used for years, is to import your remote data then export it locally as comma delimited CSV.
That is also a method I used for remote Oracle to local SQL Server, and it worked very well.

[bruce]

also consider using SQL Import / Export Wizard which is part fo the function of SQL Management studio.


You can export the table and set the destination to a CSV file.


Bruce

DiscountASP.NET
www.DiscountASP.NET (http://www.DiscountASP.NET)

[realized]

Is there an easy way to do this? What software do i need?

I have searched and found nothing. And doens't appear to be able to from my control panel either. I can justs create the .bak files.