Groups | Blog | Home
all groups > sql server replication > september 2005 >

sql server replication : Snapshot Replication and Merge Replication


Chen
9/12/2005 10:05:54 AM

Does Merge Replication take much more time than Snapshot Replication.

I run Merge Replication from SQL Server enterprice manager and alway tell me
timeout expire.



Thanks




Hilary Cotter
9/12/2005 9:26:26 PM
Yes it does. You need to bump up QueryTimeout to something large to solve
most timeout problems.

--
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
[quoted text, click to view]

M
9/13/2005 2:40:57 PM

Thank you very much.
Is it possible to set the QueryTimeout from SQL Server Enterprise Manager?



[quoted text, click to view]


AddThis Social Bookmark Button