Sad thing that people feel the need to plagiarize. But, thanks for turning this into something positive.

Whipped this up just to try to get a book. Used AdventureWorks database in...

Yes, I kept trying to...

Thanks for the interesting question. I got caught out with "Phone". Don't really use this kind of thing in my work right now. But, as with many QotD topics, it...

+1, but a nice, easy question for a Monday.

Nice question!

Here's a useful SQL Server Script to list database name, login type, server login name,server role, database user and database role[/url] I found.

I have a different link: http://msdn.microsoft.com/en-us/library/ms143729(SQL.120).aspx that yields the same info.

Features are deprecated, not removed.

Excellent question. Simply explained and good references. Thanks!

Thanks for posting this. I just had to do a cold reinstall and restore of my DB server. Has to reconstruct the users/logins from memory! Now I can just run...

L' Eomot Inversé (11/11/2013)

---

... as far as I can tell it is nowhere documented that these 4 functions are additions to T-SQL in 2005; of course each has its own...

Thanks for the question!

However, the drama of saying that it caught out all your staff made me spend way too much time on it. Thinking I was missing something,...

Good question, even with the case sensitivity issue left open. As a general rule, better to specify server settings that were in place, than to expect answerers to make the...

bryanellis (11/7/2013)

---

This reminds me of a programming test I had when in college. The professor gave us a single task: get the top 10 student names alphabetically from the...

Liked that it made me think. Not thrilled with the explanation. Got it right in the end, but fall into the category of "It depends" being a better answer.

Thanks for...

L' Eomot Inversé (11/1/2013)

---

Could have been a good question, but seems to have got a bit muddled somehow. The muddle is a pity, as there is at...

SqlMel (10/31/2013)

---

I find this one to be a very good question but one that can be easily answered by just analyzing the available options.

First, you need to select 4 correct...