473,383 Members | 1,925 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,383 software developers and data experts.

REPLICATED SERVERS Index FT Data differently.... WHY?

I've got 2 SQL server 2000 machined synched up using replication and there are full text catalogs running on 2 of the tables. the tables have the same number of records (as they're replicated) and when I freshly build the Full Text Catalogs on both the servers and run the same query against both the databases utilizing the Full Text Indexes... I get a different number of results returned. :-(

why would the number of records vary between replicated servers???
Aug 21 '07 #1
1 1009
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!
Aug 21 '07 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

1
by: Sunit Joshi | last post by:
Hello All I was wondering if there's a way to monitor/measure data-transfer being taking place between 2 serves in a replicated environment. I cannot see any counters, etc. to monitor this..?? ...
1
by: miltonmoura | last post by:
Hi, I am using Merge Replication for synchronizing a bunch of laptops running MSDE with a central SQL Server 2000 production server. This database is used by an application that needs to know...
4
by: jane | last post by:
HI, I try to create summary table like following: create table summary (a int, b int, c int) (select a.aa, b.bb, b.cc from table_a a ,table_b b where a.key=b.key) data initially deferred...
0
by: Bill Ehrreich | last post by:
I have an A2000 application that I have designed to use a replicated Access database. The application permits information to be gathered on cardiac patients in a hospital system. Most users will...
2
by: gordonjones | last post by:
I have users on different computers getting the error message "could not update;currently locked" when trying to leave identical fields after making a change on the same form but on different...
1
by: JC | last post by:
I have a table which is replicated for after images only. I tried to do an import using the replace option into the source table with data. For some of the rows, they were not in the import file,...
1
by: aine_canby | last post by:
Hi, My company has an old access database which has been in use for many years now by a few employees. I need to make some design changes to one of the forms, but I'm not sure how I should go...
2
by: Eric L | last post by:
A client has a split database. However, the frontend is replicated. Since both frontend databases(replicated + DM)are both on same network drive, we would like to remove the replication of the...
3
by: Bob Alston | last post by:
I have a system built using Access replication. After some initial problems dealing with memo fields, it now seems to be working well. I am curious as to how frequently others Compress & Repair...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: ryjfgjl | last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.