Lynn Pettis (9/21/2013)

---

I learned more when I became more involved on SSC and started trying to help others. Several key people showed me better ways and I learned from...

Jan Van der Eecken (9/20/2013)

---

I don't think I'm the lone non-US citizen who doesn't quite understand what the Filibuster is all about. The way I understand...

jasona.work (9/20/2013)

---

It strikes me as somewhat amusing to see someone post a question, which is obviously not a "help me fix this" but is instead a "help me understand why...

I would remove that other group and then add the MSDTC to the SQL cluster group.

It's been a while since I've done replication, but can't you take a current backup of the database, restore it to the subscriber, then rebuild the subscription details?

If you're having...

Stuart Davies (9/26/2013)

---

Already thought of that one Brandie - however...

tlawrence71 (9/26/2013)

---

I broke the replication for a software DB upgrade that cannot be done when replication is enabled Both My Main SQL cluster and the reporting server are on...

At risk of starting another rant, if you're already updating the stored procedure, variables are easy enough to rename.

Data Mirroring is also an option. But...

You broke replication for an upgrade. Why did you not upgrade the other server? If you did, why did you not rebuild / reinitialize...

Really?

I don't remember seeing that available in my install files. Now I'm going to have to go try it...

Hrm. Something else to learn...

Oh, dear... Yes, I have been down this road before (old employer). If you are going to have multiple clients on the same box, do absolutely make sure they are...

You can't upgrade an instance separately from other instances. It's all or nothing.. Or a side by side install.

I would recommend installing a brand new R2 instance in a different...

My comments vary. Usually we start off with the following:

/****************************

InstallDB: MyDB1

CreatedBy: Brandie

CreatedOn: 2012.09.26

Description: This proc pulls the orders made within the last week that were not

...

Daniel,

I would agree with Andrew. This sounds like a case of your services running under a local account instead of an plain vanilla Domain (Active Directory) account. Local accounts can...

Bhuvnesh (9/24/2013)

---

Brandie Tarvin (9/24/2013)

---

But it doesn't explain why the second update (which does much the same thing on different columns) is able to use its index. It does an Index...