I appreciate if you can provide more information on the custom stored procs.

MysteryJimbo (10/31/2013)

---

It depends a little on how much data is building up and if its causing an issue. In a high throughput distribution db you can have the replication...

SQLSteve (10/30/2013)

---

This is not required - The account just needs to...

there must be some other process on the subscriber which might have inserted that row. Try to delete that row from the subscriber after saving the data. The replication should...

DDL changes should reflect on to the subscriber. And you said it worked on test environment. Please try to check again.

They are SAN drives. No info in the event logs.

Database contains stored procs. So you want me to inspect all those stored procs and find the logic. We have php scripts running at the frond end which fill the...

I was successful in installing the multi node multi instance clustering. But I was not able to connect to the server. Error in error logs says cannot connect to the...

Have you just applied Windows 2008 R2 SP1?

This is a new node we are trying to add to the existing two node cluster group. I have read somewhere that this...

I was able to add new node to the existing cluster. But I am lost on how to install sql instance on this node. Do I need to specify the...

In my case Node A and Node B are very high capacity servers. On these nodes we are running our most critical instance(instance1). Currently the instance1 is running on Node...

Thanks a lot Perry. I really appreciate your help.

If possible, I want to make all the disks available on all three nodes and introduce the affinity rule so that...

Thanks Perry. Too many questions. I have setup a two node cluster and now adding a third node to it. I have asked for 3 drives for system db files,...

Perry,

Do we need to have multiple witness disks if we want to go with this type of setting?

Thanks Sailorking and Perry!