Not a real easy one.

It all depends e.g. on:

• The number of changes (inserts / updates / deletes)
• How often the subscribers synchronize
• The type of data (ntext/text/etc)

So if you modify only 1...

Assuming you meant:

Server-A = Publisher of Database-X

Server-B = Pull subscriber to Database-X on Server-A

Server-C = Distributor

The distributor database is already created and the server is already flagged as a...

If you run the merge agent continuously (parameter -continous for the agent) you could add another jobstep which waits a couple of minutes and resumes execution at job step 1...

Glad the problem is sorted out now.

Click: Start->Run, type in: services.msc

Scroll down to SQLSERVERAGENT. What do you see in the Logon as column (last column). see image below

In this scenario...

Can you connect to the SQL Server (assuming the server is running and only the agent is not) using the exact same username and password combination entered for the service...

The password for the SQL Server Agent startup service account is incorrect (probably changed).

Solution

To solve this problem, type the correct password in the Microsoft SQL Server agent service account on the...