Congrats, indeed.

The first question I have is, why is it necessary to edit the data at all?

The second question is, why did you choose this manner in which to update it?

And...

They changed the email passwords on me and I've yet...

I suppose that wouldn't be a bad question to ask prospective employers. When they say "Do you have any questions for us" I could come back with "Tell me about...

Eureka!

Check the package's ProtectionLevel (package properties). I bet it's set to EncryptSensitiveWithUserKey.

Change it to DontSaveSensitive, save it, and put it back up on the server.

Google the term "switch SQL Server services...

Lynn Pettis (9/26/2013)

---

I was notified this evening that my position state side has been cut as part of company layoff. Unlike my fellow workers state side whose last day...

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.