|
|
Posted by Hilary Cotter on 09/08/05 13:20
Consider distributed transactions for this. You can also set your polling
interval on your log reader and distribution agent to 1s, and your latency
will be around 10-20s.
--
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
"Neil" <nospam@nospam.net> wrote in message
news:8KRTe.2584$9x2.1236@newsread3.news.pas.earthlink.net...
> Is it possible in SQL Server to have replication happen immediately as
> changes are made. That is, a change is made on server A, and that change
is
> automatically applied to server B, rather than the replication happening
at
> set intervals?
>
> Thanks.
>
>
Navigation:
[Reply to this message]
|