Hey..

How big is the table that is taking a long time ?

What is your connection like to your subscribers ??

Have you thought of applying the data via BCP (a data...

Hi..

You need to have a bit of a read.

If you are setting up replication with identity ranges..you should at least know were to check them and what they do..

Try BOL...

Yes applying a new snapshot is a last resort..

In your situation, you needed to let the logreader "catch up" as there were many transactions in the TLog. This may have...

Hmmm...not pretty

You are going to have to generate a process that, for each table,

generates a new table with the same schema which includes the NOT FOR REPLICATION, insert the...

Can you check which account your agent is using to connect to the subscriber. This will be under Configure Publisher,Subscriber,Distirbution ...under Tools

Regards

Graeme

Are your INSERT procedures/queries explicitly listing the column headings ?

How is the insert failing ?

What is your error ?

Thanks

Graeme

Hey..

That's quite a big question...and I'm not sure it has a fixed answer.

IMHO...as bad as it sounds, I think it really depends on a lot of factors...types of replication, amount...

Hello,

The snapshot agent is not triggered by anything. Unless I've missed something. It will have it's own job which may or may not have a schedule. This is controlled by...

Why are you running the snapshot agent again....is it scheduled. This should only be run when you first synchronise.

Regards

Graeme

I agree..

It does depend on what is replicated and and what needs to be changed.

An ALTER TABLE command needs to drop and recreate the table and this is not possible...

Hmmm..interesting.

What replication type are you using ?

What are thr properties for the Articles in your publication ?

Thanks

Graeme

Hi,

Do you mean your distribution agent is failing?

What type of replication are you using ?

Thanks

Graeme

Hi,

We recently upgraded our production from 2000 TO 2008.

We did this by detaching all user databases, upgrading the engine and reattaching.

We don't have the resources for side by side which...

Hi,

I have a degree in Civil Engineering...bridges, roads, dams...all that sort of stuff.

As the editorial suggests I did have a deep rooted interest in IT...

I grew up with MD DOS...

Hi..

I've read a few of the posts and found them quite interesting...I haven't managed to read all of them so I might be repeating other posts....but here goes.

I do think...