How can I copy a whole table and some certain records from one DB to another.
The two DB are identical, but run under a diffrent Ip address.
I execute the SQL commands in MFC application, and connects the DB by ODBC connection.
I know the option of using "sp_addlinkedserver" , but I need to make the connection by IP adderess or by ODBC somehow.
I dont want to let one server to know the registration name of the other server,however I want them to know each other by thier Ip Address.
I am using SQL Server 2000.
THanks in advance !!!