>>Hi All,
>>I have 2 servers Name "ASHI" and "JAIN". both have same database name "ORS". I want to find out how many records different in a table name "app". what is the sql query to find out the number of records different in this table. Any Clue???
>>
>>Thanx,
>>....ashish
>
>SQL Server tables are identified by Server.Owner.Table. What determines if records are different?
>
>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 appashi)

Forgot to add the alias at the end of the subquery.