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

I've started looking for some, and we'll see.

I think many of the people at SSC are worried about cost, others worried about security or legal issues. There are people using...

GilaMonster (5/26/2011)

---

Roy Ernest (5/26/2011)

---

I have an idea for one of persons who want to go to SQL Pass summit for free (Except air travel). Make list here who wants to...

"may" speaks to possibilities. Extents can be uniform (one object stored) or mixed (multiple objects stored)

Perhaps another word would be better, but I do see so many of our executives as being greedy. Not evil, but getting caught up in the Lord Byron quote about...

Ditto. Hopefully I'll get to see it on a recording or live in Oct.

Apologies on the year. I've corrected that.

I should have noted this is OS dependent. My apologies for that. From the explanation URL: NULL if the CHECK_POLICY or CHECK_EXPIRATION is OFF...

AFAIK, from the licensing docs, if you have 2 sockets in your server, you need two licenses. You cannot set affinity for one processor according to the Microsoft documentation.

Page 4...