July 8, 2008 at 8:37 am
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:
July 9, 2008 at 7:52 am
there was an index service running on the sql-server which was used, instead of the one on our file server
:Whistling:
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply