如何查询远程索引目录
|
我一直试图在SQL Server中创建一个链接服务器，以访问
远程索引服务目录，但是我似乎做不到。让我们打电话
远程服务器“ remoteServer”和目录“ remoteCatalog”
我已经试过了：
EXEC sp_addlinkedserver remoteIndexServer, \'Index Server\', \'MSIDXS\',
\'query://remoteServer/remoteCatalog\'
SELECT * FROM OPENQUERY(remoteIndexServer,\'select filename from scope()\') AS Q
OLE DB provider \"MSIDXS\" for linked server \"remoteIndexServer\" returned message \"Service is not running. \".
Msg 7320, Level 16, State 2, Line 3
Cannot execute the query \"select filename from scope()\" against OLE DB provider \"MSIDXS\" for linked server \"remoteIndexServer\".
没有找到相关结果
已邀请:
1 个回复
臂哦
SELECT * FROM OPENQUERY( LocalLinkedServer, \'select filename from RemoteServer.CatalogName..scope()\' ) AS Q