July 6, 2005 at 1:35 am
Hello,
I have a major problem. Due to a change in server structure, I can no longer place my Indexing Service Catalogs on the same server as my sql server so I have done the following:I have a webfarm of two windows 2003 servers in a nld cluster. On webserver 2 I have a sql server with a linked server to the index catalog. This is all inside my DMZ. Inside the network I have a SQL Server Cluster which is linked the the SQL Server on WebServer2. We need to be able to query the index catalog as though it is on the SQL Cluster. I had attempted to do this by setting up a job to extract the data from the catalogs into a temporary table on the SQL Cluster but have found that the CONTENT field of the Index Catalog is read only so can only be queried and not extracted. How can I query the index catalogs on the webserver in the dmz from the sql cluster? Can anyone help me please????? I'm really tearing my hair out with this one.to refresh WEBSERVER2 has sql linked to the catalog filesthen the SQLCluster is linked to WEBSERVER2 SQL ServerI need to query something along the lines ofSELECT * FROM OPENQUERY(SQLCLUSTER.WEBSERVER2SQL.WEBCATALOG, 'SELECT FileName, Path, VPath FROM SCOPE()')
July 7, 2005 at 3:20 am
When querying index server on a physically different server you need to use slightly different SQL to tell SQL server where the catalog resides, you also need to use 2 dots after the catalog name see example code.
SELECT fileName FROM OpenQuery(CatalogName, 'select FileName from ServerName.CatalogName..SCOPE() WHERE Contains(''search string'') > 0'))
The linked server itself is created in the normal way, you just need to change how you access it.
Andy
July 7, 2005 at 3:48 am
Or you create a view on server1 that points to server2 via an OPENROWSET..
karl
Best regards
karl
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply