linked index server returns incorrect results

• Michael Niemand

  Ten Centuries

  Points: 1149

  More actions

  July 8, 2008 at 8:37 am

  #193526

  Hi folks,

  I use a linked index server to search for documents combined with sql in my SQL Server Express.

  If I query the index service itself (from computer management - index service - query catalog) I get a different number of results as if I run the same query (same catalog, same server, same criteria)

  Is that some kinda bug or am I doing somethin wrong?

  here be some details:

  SQL QUERY:

  select * from

  OPENQUERY ([GRIP-SERVER], 'select FileName from

  scope() where contains(''cmbs'')')

  Where GRIP-SERVER is our linked server which has "Web2" set as Datasource

  When I query directly, I click on "query catalog" under "web2" under "Index Service" in the computer management and type in "cmbs"

  sql: 24 rows

  idxs: 44 rows

  also tried scope(''DEEP TRAVERSAL OF "/allecvs/"'') to make sure all subfolder are included

  :blink:

• Michael Niemand

  Ten Centuries

  Points: 1149

  More actions

  July 9, 2008 at 7:52 am

  #840153

  there was an index service running on the sql-server which was used, instead of the one on our file server

  :Whistling: