Hi,

It really does depend.

What is the server being used for. You may find disk is more important that memory.

A SQL Server configuration can very enormously depending on it's...

Hello, the whole point of replication is to keep your schema data and schema in synch.

What are you trying to achieve ??

Regards

Good Topic...well I think so anyway

I think problem solving is a key skill and is something I rate quite highly in an individual. It shows a methodical approach and a...

Interesting Topic

We have a very complicated process to deploy our product. We use a combination of msi and powershell and manual configuration. Talk about work of art, this belongs in...

Interesting article.

Personally, I am a firm believer of becoming an expert. Someone who knows their job well. As a far as a DBA is concerned I think the newer versions...

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...