You are here: Re: SQL 2005: Transact. Repl. > Executing sp on subscriber doesn't execute on publisher « MsSQL Server « IT news, forums, messages
Re: SQL 2005: Transact. Repl. > Executing sp on subscriber doesn't execute on publisher

Posted by Hilary Cotter on 09/28/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

 

Navigation:

[Reply to this message]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация