Re: Question about replicating stored procedure execution
- From: "Hilary Cotter" <hilary.cotter@xxxxxxxxx>
- Date: Thu, 9 Feb 2006 20:32:17 -0500
Exactly. Its not commonly used because most people don't know about it, and
secondly sometimes the tables referenced by the stored procedures are
different on the publisher and subscriber and therefore you get different
dml on either side.
Other people want the proc run within a serializable transaction for
consistency, which is another option. Is the proc is not run within a
serializable transaction, the DML is replicated instead of the proc.
--
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
<pshroads@xxxxxxxxx> wrote in message
news:1139532907.083047.89490@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
I am doing some research in advance of setting up replication. I've
read about replicating stored procedure execution and I need
clarification on what it is exactly.
My understanding is that, for example, if you have a stored procedure
on the publisher that modifies 10,000 rows then replication will not
replicate the 10,000 modifications to the subscriber but will rather
pass along the execute command which will then be executed locally at
the subscriber. Do I have that correct?
Is this a common practice in a replication scenario?
Thanks
.
- References:
- Question about replicating stored procedure execution
- From: pshroads
- Question about replicating stored procedure execution
- Prev by Date: Question about replicating stored procedure execution
- Next by Date: RE: Security Error on WebSync
- Previous by thread: Question about replicating stored procedure execution
- Next by thread: Re: Replication Conflict Notification
- Index(es):
Relevant Pages
|
