Posted by Hilary Cotter on 09/30/00 12:00

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

• Next in forum: Re: Need Help Importing Data from Excel to My SQL Database
• Prev in forum: Re: How top actually works
• Thread view: Re: SQL 2005: Transact. Repl. > Executing sp on subscriber doesn't execute on publisher

[Reply to this message]