Replication creates new triggers?

I have just created a Publication and now most or all of my triggers have
been duplicated and given a name like ins_03FA9EAD39A54B18B6276581AA1F0C42.
Is this doe in replication setup? Thanks.
David
These are merge replication specific triggers. They are created in the
snapshot process on the publisher, and also when the snapshot is applied on
the subscriber.
Hilary Cotter
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
"David Chase" <dlchase@.lifetimeinc.com> wrote in message
news:uXbEBbRHGHA.528@.TK2MSFTNGP12.phx.gbl...
>I have just created a Publication and now most or all of my triggers have
>been duplicated and given a name like ins_03FA9EAD39A54B18B6276581AA1F0C42.
>Is this doe in replication setup? Thanks.
> David
>

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...
>
>