Re: SQL 2005: Transact. Repl. > Executing sp on subscriber doesn't execute on publisher

#1

Begin tran
update server1.database1.dbo.table1 set col1=4 where pk=5
update server2.database1.dbo.table1 set col1=4 where pk=5
commit tran

--
http://www.zetainteractive.com - Shift Happens!

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
"Patrick" <patrickmwolf (AT) gmail (DOT) com> wrote

Quote:

On Jan 16, 5:33 am, Hilary Cotter <hilary.cot... (AT) gmail (DOT) com> wrote:
You can't. Basically only table changes are replicated back to the
publisher.

You will need to code something perhaps using a distributed
transaction which will execute this on the publisher as well as the
subscriber.

Thank you for your answer. Would you be able to give me a simple
example of how I could code something?

Thank you very much,
Patrick

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: SQL 2005: Transact. Repl. > Executing sp on subscriber doesn't execute on publisher

comp.databases.ms-sqlserver comp.databases.ms-sqlserver

Re: SQL 2005: Transact. Repl. > Executing sp on subscriber doesn't execute on publisher - 01-17-2008 , 09:30 AM