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

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" wrote in message
news:dea28d00-f8aa-499f-aa34-f1c012bac92e@e32g2000prn.google groups.com...
> On Jan 16, 5:33 am, Hilary Cotter 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