Forum Replies Created

Viewing 5 posts - 31 through 35 (of 35 total)

  • RE: tran_replication problem

    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...

  • RE: Largest Replicated Database

    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...

  • RE: variables in select lists in SQL7

    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...

  • RE: Remote DR site suggestions

    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...

  • RE: Service Packs

    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...

Viewing 5 posts - 31 through 35 (of 35 total)