Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Indexing Services linked server

Author  Topic 

iminore
Posting Yak Master

141 Posts

Posted - 2006-01-30 : 10:32:23
I've set up a catalog in Indexing Services on serverA that points to local file folders and folders on serverB (both running W2000). Searching in IS query finds documents on both servers. I've created a linked server in SQLServer on serverA that has the catalog as data source but I can only find folders on serverA with this statement:

select * from OpenQuery(linkedserver, 'select directory from scope() order by directory')

Any ideas why this does not find files/folders on serverB ?
   

- Advertisement -