Copy ms sql table with data

Hi All,

I want to copy a microsoft sql database table from one database to another with the all data. And also those two databases are located in two PCs.

Can anyone help me to do this.

Thanks

You can use DTS for this if it is SQL Server 2000.

Thanks for the response. Actually it's sql 2005 express edition.

You will need to create a linked server then you can copy using a select into statement