Actually I've discovered WHAT is happening to account for the different result sets, but not WHY it's happening.. perhaps you've got some ideas?
if I run the following statement on the 2 databases I get different results:
"SELECT TOP 200000 2 As STYLE, Websites.BRANCH_ID, LTRIM(Websites.TITLE) As DISPLAY, Websites.WEBSITE_ID, Websites.LINK FROM Websites WHERE CONTAINS(TITLE,'"yahoo.com"') ORDER BY DISPLAY"
ON DB1 all results containing "yahoo.com" are returned.
DB1 RESULTS:
"yahoo.com - Maps of Rushville, Missouri, USA"
"yahoo.com - Maps of Rushville, Texas, USA"
However on DB2 it does something very different all results containing "yahoo.com" as PART OF A WORD are returned:
DB2 RESULTS:
"weather.yahoo.com - Weather in New Haven, Connecticut"
"clubs.yahoo.com"
"yahoo.com - Maps of Rushville, Missouri, USA"
"yahoo.com - Maps of Rushville, Texas, USA"
NOW,
The records for clubs.yahoo.com do exist and ARE indexed in the Full Test Catalog on DB1. you can see them if you change the Where Clause to CONTAINS(TITLE,'"clubs.yahoo.com"')
Why does DB2 return results where Yahoo.com is PART of a word (Like clubs.yahoo.com) whereas DB1 will return only results where "yahoo.com" exists on it's own and not as part of a word....??????????????????????????
PERPLEXED!