Selecting across domains

[DirtyB]

I have two identical SQL Servers on two different domains. I need to get half of the data from a certain table on the first server, and half of the data from the same table on the other domain on the second server into the same table. I really need to be able to say "Insert into server2.table1(select (criteria) from server1.Table1)"

Is this possible, what is the syntax?

Thanks

 

[DirtyB]

bye the way, there is a trust between domains if that makes a difference

 

[RickCole]

If the trust is setup correctly and you have the servers linked you should be fine with the following:

Insert into server2.database_name..table1(select (criteria) from server1.database_name..Table1)

Rick.