Morning,

I think these are great. I totally agree with them and I agree that the goal is not always peace and harmony (although hope springs eternal), it is a mutual...

Yes indeed. A rather touchy subject for me 🙂

Our deployments used to be handled by DBAs. We would do all the database changes in a way we could manage and...

Waste of time putting all that on here.

Start by writing the sql script that would perform this task and work from there.

I may be worng but this sounds fairly...

Well it's telling what the problems is. An attempt is being made to update a row at a subscriber and it is not there. Sounds like error 20598 to me....

If you are running ALTER statements or drop and creates it might be more manageable to run each one as a separate script..perhaps using sqlcmd. You can then output to...

ALso, I assume you you don't have a login mapping as you are using a specific remote login correct ??

Under Linked Server properties, is Data Access, RPC and RPC Out set to true ??

Graeme

Yes..we have a database that is a merge subscriber and is republished as a transactional publisher..no problems.

You may want to have a think about how you want it to work...

Can't you just use the Alter table command and the dropped column will be dropped from the subscriber auotmatically. As replication now supports schema changes.

HTH

Graeme

I agree merge has the highest support overhead, but it is pretty resilient and if you have the right system in place it should be fine. A careful use of...

Is that script generated using the SSMS option.

It does tend to assume you are starting from scratch to create the publication.

Shouldn't there be accounts that are members of the Publication...

Yeah..you need to have a little read up on replication. Although merge is one of the more complicated forms, it's still fairly easy to set up. And as mentioned you...

Hi,

I think you need to read a little bit more about replication. Especially if you are supporting a production server.

Your answers to my questions suggest a very limited knowledge.

My advice....

Sorry I'm a little confused.

You are using Transactional replication..is that correct ?

What is failing at midnight ?

Is it the distribution agent or the snapshot agent ?

Can you tell me where...

For transactional replication, the snapshot is only applied once to sync with the subscriber.

Are you saying that you have transactional replication configured so that the snapshot agent runs every night...