Hello,

We are using tablocks.

Our system is SQL2000 SP3a.

Interesting point from Mel although I don't think that applies to us...a reboot might be worth a try.

Still looking at the TSQL now....and...

Hello,

We are using tablocks.

Our system is SQL2000 SP3a.

Interesting point from Mel although I don't think that applies to us...a reboot might be worth a try.

Still looking at the TSQL now....and...

Morning...

Well, I tried rebuilding the tables before the population (this runs at 2:00 am).

No joy...the step still took 4 hours. I guess the next step is execution plans.

I actually managed...

Hey,

That's the frustrating thing...there are no error messages being generated ???? None in the SQL error log or the WIndows error log

Job history shows the steps completing but one step...

Hey John,

Yeah..thought about that one.

Problem is the publisher is updated all the time and the subscriber is only updated once a day.

I'll have a think

Cheers..Graeme

Sorry...missed a bit.

You can create a script that generates the triggers automatically and writes the entire row before change into a column and the entire row after change into another...

Hi,

This can be as complicated as you want it to be.

One idea is to have INSERT, UPDATE, DELETE triggers on your tables that capture Tablename, Column, PK Value, Old VAlue,...

Thanks Colin.

It looks like a server process was hogging memory....bit of a worry but one to keep an eye on.

Thanks for your input.

Graeme

Hey James,

Thanks for your input.

I shall certainly take your comments into consideration.

We actually have to do a full population each night because the table is totally rebuilt.

Thanks again

Graeme

I seemed to have found the problem.

The server had been built with the wrong and then the name was changed to what it should be....without me knowing

Hey,

Thanks a lot for your comments.

I will endeavour to sort my problem.

Regards...Graeme

Hi

The Not For Replication is certainly a solution in this case.

As far as ordering goes, when a batch of commands are replicated they are put in an order. They use...

Hi,

Do you know at what point this error occurs?

Is it right at the beginning?

Graeme

Or you can save the package as a .dts file and then open this on the new server.

Regards..Graeme

That's a very good point Rudy...

Thanks..Graeme