How to set the location of a linkedserver?

Hey folks,
I have a WinNT4 machine with the indexing service setup on it. It works.
Also I have a W2k machine running SQL Server 2000. I'd like to add the
indexing service on the WinNT4 machine as a linkedserver to the SQL2000 DB
on the W2k machine.
If the DB as well as indexing service are on the same machine I use this:
sp_addlinkedserver CVDOC, 'Index Server', 'MSIDXS', 'CV'
From reading online I understand that as a 5th parameter you can give the
storedproc a location for the linkedserver however I have not been able to
make this work.
What should that location parameter look like? UNC? Web?
On the NT4 server my documents to index are in C:\somefolder\CV\
The catalog name is CV and points to this location.
Any help would be very much appreciated.
Thanks for reading sofar,
Vincent.
From what I understand the catalogs and services are completely different,
so you can't query a NT 4.0 IS server or its catalog from Win2k.
Hilary Cotter
Looking for a SQL Server replication book?
Now available for purchase at:
http://www.nwsu.com/0974973602.html
<koopman@.furore.com.removethis> wrote in message
news:eLi5QiUzEHA.1264@.TK2MSFTNGP10.phx.gbl...
> Hey folks,
> I have a WinNT4 machine with the indexing service setup on it. It works.
> Also I have a W2k machine running SQL Server 2000. I'd like to add the
> indexing service on the WinNT4 machine as a linkedserver to the SQL2000 DB
> on the W2k machine.
> If the DB as well as indexing service are on the same machine I use this:
> sp_addlinkedserver CVDOC, 'Index Server', 'MSIDXS', 'CV'
> From reading online I understand that as a 5th parameter you can give the
> storedproc a location for the linkedserver however I have not been able to
> make this work.
> What should that location parameter look like? UNC? Web?
> On the NT4 server my documents to index are in C:\somefolder\CV\
> The catalog name is CV and points to this location.
> Any help would be very much appreciated.
> Thanks for reading sofar,
> Vincent.
>
|||And what if I was using another w2k server instead of NT4?
What makes you think the catalogs and services are different? Something I
wrote or is that a fact because I use an NT4 server? I don't get this part
of your message...
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:eP6d5aXzEHA.2788@.TK2MSFTNGP15.phx.gbl...[vbcol=seagreen]
> From what I understand the catalogs and services are completely different,
> so you can't query a NT 4.0 IS server or its catalog from Win2k.
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> Now available for purchase at:
> http://www.nwsu.com/0974973602.html
>
> <koopman@.furore.com.removethis> wrote in message
> news:eLi5QiUzEHA.1264@.TK2MSFTNGP10.phx.gbl...
DB[vbcol=seagreen]
this:[vbcol=seagreen]
the[vbcol=seagreen]
to
>
|||Win2k to Win2k will work fine. Win2k to NT 4 or vice versa won't as the IS
server, the catalogs, and most importantly the providers are all different.
Hilary Cotter
Looking for a SQL Server replication book?
Now available for purchase at:
http://www.nwsu.com/0974973602.html
"news.micosoft.com" <koopman@.furore.com.removethis> wrote in message
news:eMAvcFYzEHA.2316@.TK2MSFTNGP15.phx.gbl...
> And what if I was using another w2k server instead of NT4?
> What makes you think the catalogs and services are different? Something I
> wrote or is that a fact because I use an NT4 server? I don't get this part
> of your message...
>
> "Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
> news:eP6d5aXzEHA.2788@.TK2MSFTNGP15.phx.gbl...
> DB
> this:
> the
> to
>