I have a table on two different database servers on server-1 it contains almost 2090 records and on server-2 it is empty i want to copy all the records from server-1 to server-2 both the database servers are identical but on different location and have no relation with each other

Please help Thanks

You need to copy only the table data rather than entire table.

Please read more here.

SQL Server Management Studio's "Import Data" task (right-click on the DB name, then tasks) will do most of this for you. Run it from the database you want to copy the data into.

Thanks Gulbano it really worked for me :)