Thank you very much for the prompt reply.

I was getting stuck with the insert statement (didnt read BOL properly about the 'deleted' table) so i was inserting from the...

HI all,

thanks for the responses. I came to the same conclusion and I actually managed to achieve my goal with the following script:

INSERT INTO MC_TEST (itemnmbr, old_branch,[month], inv_VALUE, cme_value)

SELECT...

This is what i have so far. The @emailist is configured with the cellphone/mail account through your service provider. The script works fine, but i initially thought i would...

Excellant! Thanks a stack, this worked perfectly!

Ganesh, thanks a stack! This is exactly what I needed!

Guys,

What i actually did was drop all my articles and publication because there was data inconsistency across the board. I recreated the entire replication process, with separate publications containing articles...

Thanks Guys, we finally had to reboot the server because of this and some other issues.

Thanks for the Info John, i will give that a try.

After testing this scenario on the test box, I am going to create a separate publication for this large...

Hey Hey, it worked!!!

Thanks a stack, your help is most appreciated!