sql server 2000 - backing up tables 1

[duchovnick]

Hi ,
This is a "very beginner's question" but i still need help with that.
I need to copy a table to a disk or send it to a remote computer via email. Where do i find a "sql server table" on the disk ? What is its extension ? Name ? does it carry the same name given to it in SQL Server on the hard disk ?
In short: How to i copy a table to another disk ?
Thanks a lot.

 

[ptheriault]

you would have to export the table to a file. like csv or txt. Tables reside in the database. If you right click on the database in Enterprise Manager, select export and follow the wizard.

- Paul
- If at first you don't succeed, find out if the loser gets anything.

 

[duchovnick]

Thanks !