How do i copy a table from one server to another

[spartan7]

I need to copy a few tables from a database on one server, to another database on another server. How do I do it?

I don't want to backup the entire db because it's massive. Just a few tables.

I'm using microsoft sql server.

Thanks

[chazzy]

you can either do an export or a partial back up. both should be done from sql server enterprise manager.

[spartan7]

I'm using microsoft SQL server management studio and studio express to manage the servers. Where do I find those functions to export and/or partial backup?

[chazzy]

you would remote desktop to the servers to do this. it might also be in sql server management studio, try right clicking on the connection. it might be dependent on your authentication level though.

this should give you some direction (from MS Technet)

http://technet.microsoft.com/en-us/library/ms187510.aspx