>SQL Server tables are identified by Server.Owner.Table. What determines if records are different?

The full name of an object consist of four components: server.database.owner.object.

>The following will check for records that do not exist in JAIN but do exist in ASHI:

>select appjain.* from jain.dbo.app appjain where appjain.key not in (select appashi.key from ashi.dbo.app)

>HTH.

You will have to create a link server on JAIN that points to ASHI. See the BOL for more info on Linked Servers.

-Mike