Replication and use of Remote Server

When Replication is configured it creates a remote server connection. Can it
be configured to use Linked Server instead? Linked server seems to have all
the same capability as Remote Server (and more).
LMK
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
"LMK" <LMK@.discussions.microsoft.com> wrote in message
news:6DD94C8B-7AB8-463D-A4DB-CA42A3C5E7B1@.microsoft.com...
> When Replication is configured it creates a remote server connection. Can
> it
> be configured to use Linked Server instead? Linked server seems to have
> all
> the same capability as Remote Server (and more).
> --
> LMK
|||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
"Hilary Cotter" wrote:

> 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
>
> "LMK" <LMK@.discussions.microsoft.com> wrote in message
> news:6DD94C8B-7AB8-463D-A4DB-CA42A3C5E7B1@.microsoft.com...
>
>

Replication 2 part update in SQL2005?

SQL2000 used to send a 2 part update using sp_msdel followed by sp_msins instead of just calling sp_msupd. I thought this used to happen on tables with compostie primary keys. Does any know know if this still occurs in SQL2005 and maybe why?

I think I found the answer as deferred updates, or Singleton pairs. See http://support.microsoft.com/kb/238254/en-us

Replication 2 part update in SQL2005?

SQL2000 used to send a 2 part update using sp_msdel followed by sp_msins instead of just calling sp_msupd. I thought this used to happen on tables with compostie primary keys. Does any know know if this still occurs in SQL2005 and maybe why?

I think I found the answer as deferred updates, or Singleton pairs. See http://support.microsoft.com/kb/238254/en-us