Thanks Noel.

I just tried to re-snapshot a publication and got the same message on snapshot agent 'waiting response from the server', then I checked the sysprocesses table and found 'sos_scheduler_yield'...

Thanks again, Dick. I just checked-- we do have enough space for the distribution database.

I have one more question ( I am asking for too much). So the whole...

Hi Dick, I have a question about the database autogrowing. I understand that when snapshots happen, a bulk copy happen on the publisher, then the scripts get posted to snapshot...

Dick, thanks for the reply.

I am pretty sure its the snapshot agent being slow, because viewing the agent detail, it says

....

[0%] bulk copied snapshot data for article...

...

[15%] bulk...

Thanks, Manu,

I will do that then.

But since it is a dedicated SQL box, with no other active connections to it, I would think the CPU should be low...

I will look into it. Thank you!

Thanks, Manu.

I ended up disabling distribution sychronization on all other subscribers that dont need the snapshots. Then did the snapshots again and it worked.

I guess the problem is...

Thanks. That makes sense. My initial thought was these statistics commands that cause the timeout. I guess maybe not.

I ran 'EXEC sp_updatestats' on the database. I am going to...

So I ran the profiler to capture 'attention' event, I saw a lot of it happening. The 'application name' is 'SQL Server', the Database is 'Master', so I figured out...

Thank you!!

Thanks Steve!

I ran some test on a table that gets replicated together with its clustered index and nonclustered indexes. When I ran index rebuild on the clustered index on the...

It has been a while. I am still working on finding the perfect solution to our new architecture.

I am looking into peer to peer replication as a possible solution....

Thanks for the reply!

This is what I found about updatable subscriptions:

To make schema changes on a table in a publication that supports updating subscriptions, all activity on the table...

Thanks Karl and John. I will do some reading and see what I find out.

Thanks Karl and Steve for the input!

If I would use merge replication, how tricky it is to set up and maintain and how robust it is? Say, e.g, if...