Is there a reason that you can't change the DB collation once you've restored your last log?

http://msdn.microsoft.com/en-us/library/ms174269.aspx

Post belongs in the replication forum...

In any case, if I had to guess the SQL Server Agent on your distributor is running as an account that doesn't have rights to...

We use ipMonitor from SolarWinds[/url] and I love it. It supports a ton of different monitoring methods besides SNMP and you can create really nice custom reports.

If you're cheap...

How about OpenDBiff from CodePlex:

http://www.codeplex.com/OpenDBiff

Or SQL Accord Community Edition:

http://www.sqleffects.com/Articles/Product/sqlAccordInfo/aboutSqlAccordCommunityEd.html

I am not aware of a built-in way to do this. If you're looking for something short-term maybe try a third party tool like Wireshark. Longer term solutions probably require...

I agree with other posters - sounds like what you need here is a dedicated distributor. Moving distribution responsibilities off your core server will HELP performance because you're transferring the...

Forgive my ignorance, but...

What do you need to know that sp_replmonitorhelppublisher and sp_replmonitorhelppublication don't provide?

What do you...

OK. There are a lot of tabs in replication monitor. What specific information are you looking for?

If you have custom permissions at the subscriber end you could also create a post-snapshot script that will apply the permissions for you. In the GUI, specify the post snapshot...

Replication seems like an odd way of handling this to me. Did you explore the possibility of using log shipping to do this?

Here are a good set to start with. Each links to their description in BOL. Run them on your distributor:

sp_replmonitorhelppublisher: Shows high level summary of publishers. Run with no parameters...

All replication agents should have a scheduled job that you can change. Do the following:

1) Run Replication Monitor

2) Navigate to your snapshot publication and highlight it

3) Select the "Agents" tab

4)...

Are your distribution agents set to run continuously or do they run on a schedule?

Have you monitored the perfmon counters for delivered commands & transactions per second to see what...

All DCs are on the same domain. Each DC has DNS. The machines in each datacenter are configured with primary DNS as one of the local DCs and secondary DNS...

It sounds like you might have a delegation issue. Read this for instructions on how to set up:

http://msdn.microsoft.com/en-us/library/aa905162(SQL.80).aspx

The setspn commands can be a bit tricky to get right depending on...