Jeff Moden (5/28/2011)

---

What did it do...

We're fine. Horses have been on property for weeks, so...

bitbucket-25253 (5/27/2011)

---

Steve did you drive that '92 240D in Virginia when you lived and worked there. If so, you might have seen another same model, year '80 with a...

Jack Corbett (5/27/2011)

---

Sure, I could go, and attend the precon and the spotlight!

Side note for those not on Twitter, I...

bitbucket-25253 (5/27/2011)

---

Driving a Mercedes 300 1992 (Diesel with super charger) now at 303,562 miles. Change oil every 5,000 ... maintence every 10,000 costs $90.00, and runs like a charm...

Stefan Krzywicki (5/27/2011)

---

GSquared (5/27/2011)

---

A friend of mine says that what a friend of his does is buy old clunker cars, usually for around $2,000 or so. Then the only...

The passwords in native SQL Server backups are weak.

I was thinking more of managing the encryption keys/passwords for third party tools that encrypt the backups. Tools like SQL Backup...

mgraham 67977 (5/27/2011)

---

We have implemented something we call a poker key server. To retrieve a database encryption key you have to enter a long (20 character) password of which ten...

Arrgggghhhhh.

My apologies. The second sentence was intended to be an example, not part of the questions and I inadvertently phrased it backwards.

I've awarded back points to everyone so far and...

Congrats!

you don't add the service name. You add the account under which the service runs. Those are separate things.

The service name is just meta data, like the full name for...

I think that the OP said both SQL and the custom service are on the same machine (Server1) in this case. Your point is valid, and since services can move,...

Right click in SSMS the database and select Export. Use the wizard. It builds simple SSIS packages.

I think Elliot has good advice here. I'm not sure what happens here with the Local System account. Typically you run that for various services, but not necessarily those that...

Good luck, and I feel for you on the bad design.

Moving to one trigger that simplifies the update sounds like a better idea if you're stuck here. The less...