Well, all you are really trying to do is make sure the data is the same both ends of the replication. You can always do a row count to check...

Hi,

If you are unsure of using the specific sp's then it is quite reasonable to drop the merge replication to apply any database changes and then re-apply. Of course, in...

Thanks for that Trigger,

I had a feeling that was going to be the answer. My issue was FK records were being replicated before the PK record and so were conflicting....

Under the SnapShot tab you can run scripts before and after applying the snapshot. You can always run scripts that drop the FKs before the snapshot is run and put...

Hi,

It looks like Merge replication would suit you here. If your central database is the publisher you can have 4 subscribers. As each subscriber makes a change, it will be...

As an addition to my first message...

I've run a trace on the distribution to the local server and it looks like the subscription has been reinitialized and the data is...

Hi,

No need to respond to this...it was just a connection problem coupled with a lot of backed up transactions..

Thanks...Graeme

Hi,

If I remember correctly. If you reinitialize the subscriber, it will apply the next snapshot created by the snapshot agent (run at the publisher). This is basically ensuring that you...

Hi Guys,

For those of you who are interested........bad news.

The calc jobs ran about 2 hours quicker but they are still running at 8-9 hrs.

I think I need to to dig...

Easy does it.....

I have indeed run the update.

I am re-running some queries....and will definitely let you know the results.

Fingers-crossed.

Cheers..Graeme

Actually..no I didn't

That is certainly worth a go.

Thanks..Graeme

Hi,

Thanks for that.

Yes..that's right...and that would be my initial query.

The confusing thing is that the same build exists on a development box and the calcs take about 4 hours. That...

That was also my understanding !!

Thanks for that

Hi,

I would have to agree with an earlier response. The use of triggers as a means of auditing is quite simple. You can have and audit table that can store...

Hi,

Got any more detail!

Have you dropped and re-created replication recently?

What type of replication is it?

Have you added any articles to the publication recently?

What is your process in applying the replication...