Replication and use of Remote Server -- sql server replication

LMK
10/6/2006 8:12:02 AM

In this same server, we have a separate true need for a linked server
pointing back to the same master server. I cannot create a linked server with
the same name as a remote server. Therefore if I can change the remote server
for rep to a linked server instead, I have solved both problems. I am on
Win2000. So are you saying that I cannot make this change to Linked Server in
Win2000?
--
LMK

[quoted text, click to view]

Hilary Cotter
10/6/2006 11:04:32 AM

In SQL 2005 they are all linked servers. IIRC it can, you have to give it
the name of distr_admin. Drill down in remote servers to determine what the
name should be.

Why do you want to do this?

--
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.

This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.

Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about sql server replication

sql server replication : Replication and use of Remote Server