I designed and developed commercial business software using SQL Server encryption to protect credit card data. The card data is encrypted with a symmetric key, the key is protected with...

Jeez, I hate it when the answer depends more on figuring out the author's intent in the answer than actually answering the question.

If the answer is any number of rows...

Awesome, I learned what a tuple is!

Would have got it right except I was thrown by the apparent conflict that the question was for SQL Server 2008 but the last option clearly asks about SQL Server...

Well, if I'm typing the query into a SSMS window, I'll go with number 1 and finish way before anyone else 😀

I'm confused. The question asks about the severity below 10, yet the link to documentation address the severity level of 10.

So is there a special meaning to severity levels 0-9?

Error...

Its a back to the future moment.

A fine demonstration how past performance can affect future rewards. 🙂

If you want to see inspired young ladies (and young men) trying real hard to grow their inner geek, check out a FIRST Robotics competition near you in March 2010....

Ack, weird. I tried it again and got the expected results as well. I hate Mondays.

Sure, I reformatted as well, but that doesn't explain why my results were different than the posted answer. Here is the query I ran, looks the same as the QOD.

CREATE...

Huh, what?! I got the following when I tested my answer...

(1 row(s) affected)

Msg 208, Level 16, State 1, Line 2

Invalid object name 'T'.

Where did I go wrong in my...

You also cannot rename symmetric keys. Just fought that battle.

Thanks guys, this looks like good stuff!

Sure, its the log that gets the entries when someone does a login or logout of SQL Server. You can then view the logs in SQL Server Management Studio...

We use a blog for doing software design reviews. About 150 design reviewers around the world can comment on the designs at their convenience. Everyone can see the comments when...