can sp_addlinkedserver attach to remote catalog?

[Colin Abbott]

Hi,

Can you use sp_addlinkedserver to attach to an index server catalog that is not
on the same machine as SqlServer. (I can get it to work on the same machine, but
this won't be possible in production) If this is possible could someone give me
an example of the syntax to specify that the catalog is on a different server.

Thanks
Colin

[Hilary Cotter]

AFAIK, it can't be done. If you have index server on one machine and on
another machine you can use msidxs and something like this

select filename, doctitle from machine_name.catalog_name..scope()

--
Hilary
www.iisfaq.com
"Colin Abbott" <colin....@clearreason.com> wrote in message
news:00f301c0dcc4$125e8920$96e62ecf@tkmsftngxs03...