I haven't done this exactly myself but I have split off a Distributor to a remote Distributor.

Therefore I believe you will need to script of replication settings, drop replication environment...

Is it failing on the Disconnect property rather than when you set it to Nothing.

This would be because it has failed to connect in the first place.

BTW. Try to avoid...

Good on you Steve,

Yes the last line may not have been the best but it certainly wasn't as rude as the mail you received.

Your post was quite apt and made...

As you have quite rightly pointed out it is a problem.

The only way I have been able to do it is use the DTS Object Model to amend the ini...

We've recently started a project to apply SP4 to SQL Servers involved in replication.

(Trans with 158 subscribers). We experienced one similar error each time but this was easily corrected. We've...

The answer also could be worded better. Implementing snapshot replication does not necessarily imply that snapshots are being run. You could also read this as setting up snapshot replication architecture....

Oh Dear, if you get 'offended' by such a statement that's a pity.

Please read the statement in context. I would have grave concerns that Gov't databases aren't looked after by...

How often you schedule trans log backups really depends upon your system - how much data, what type of data, how many users, how much read/write activity, hardware setup, appln's...

This is actually a feature of replication believe it or not !

If you are using SQL 2000, in replication there is an option to apply scripts automatically pre-, or post-snapshot....

As the message states, you will need either to resync the subscription or if it has been setup with the NoSync option, drop and re-create the subscription.

Unsure about your last...

Yes, I apologise, you're right - I've just gone back to check my notes (Friday feeling I'm afraid !)

It is possible but its a trade off with latency.

Depending upon how often you need to 'pass' the trans logs across the the warm standby server will reflect this. If...

They're not statistics but indexes that SQL Server creates itself when it feels this index would be useful to perform queries.

Stats are different from Indexes.

Multiserver administration is useful only in certain circumstances and can't cover all options. It particularly deals with monitoring multiple jobs and alerts.

I administer over 150 SQL Server instances and use...

This is a taster of what you need.

Substitute the relevant values required.

Care with amending job schedule values using DMO as I have found they need to be amended in a...