Merge Replication

[qberta01]

Hello,

I am tasked with setting-up merge replciaiton between two SQL 2000 servers. Everything seems to go fine until I get a timeout error on the snapshot agent.

I tried to increase the timeout value by going to the Agent Profile and creating a new profile with an extended query time. However, I am not sure what steps to take next. A warning message tells me that I will have to stop and restart replication in order for teh new profile to take affect. That's where I stop......

Any advice/help would be greatly appreciated.

Thx,

Q.

 

[mrdenny]

All you have to do at that point, is to stop and restart all the replication agents which are currently running.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com