It's probably the distribution process which is failing. In Enterpise Manager on your distributor go to Management\Jobs, find the job that has job type 'distributor' (or something like that), open...

20 Gig - Transactional replication.

As Andy said it's the snapshot that's the problem. BCPing all the data. If you can afford a small downtime on your publisher you may be...

I've seen this done horribly with dynamic sql.

i.e.

@MyString = 'SELECT EventID FROM e_EventState WHERE (StateCD IN (' + @States + '))'

EXEC (@MyString)

It requires that you grant select on the...

It is painful, but not that bad. Once on your remote site and the issue with your cluster has been resolved, use the cluster as your warmstandby until you have...

If you are going to go to any SP, go to 4. You'll just have to upgrade to it again later anyway.

There are lots of fixes in SP3 & SP4...