@Uwe - Your previous post is among the one that I like most in this thread.

If interested, please...

+1

One of the lessons from...

victoria_e_wood (3/31/2014)

---

In my opinion if the user was in fact a sysadmin why would you assign him or her rights over a database, they would automatically have rights over all...

Hugo Kornelis (3/31/2014)

---

I have to agree with the others.

**comments removed *

(To my surprise, the Books Online CREATE TABLE page does not mention anything on how the default schema for the...

Uwe Ricken (3/31/2014)

---

James Lean (3/31/2014)The script doesn't mention anything about the creation of king_login, so it is implied that this login already exists. In that case, we cannot assume...

Uwe Ricken (3/30/2014)

---

Hi,

the question and it's given answer is nonsence. You talk in your "solution" about the sysadmin role!

But in your script you add the user to the db_owner role.

If...

Thomas Abraham (12/18/2013)

---

Easy question, which I got wrong, as I seem to have missed the word "cannot" (in bold font) and the number "2". I prompted selected the three that...

Trevor Tinsley (2/12/2014)

---

Might be useful to state which SQL version, as some estates have several versions available.

Btw, isn't sys.dm_exec_cursors the only DMF, the others are DMV's?

I went with the only...

.........

You are setting a tough target Tom, Copied the explanation from BOL for un-ambiguity. Sad to see that it didn't work. Could...

At least for some, the following article may be useful -

From the Answer - "The database does get set to trustworthy even though the database is read only at that point. It may not be obvious, but the trustworthy setting...

j-1064772 (3/10/2014)

---

Got it right, for the wrong reason.

I thought that only select A was part of the stored proc. and that execution of the stored proc (select A) would be...

It was funny , even though the final output was not.funny :w00t:

SQLRNNR (3/13/2014)

---

Based on the wording of the question, I have to throw this out there too!

xp_cmdshell 'net localgroup administrators'

GO

xp_cmdshell 'WMIC USERACCOUNT LIST BRIEF'

GO

xp_cmdshell 'WMIC USERACCOUNT LIST FULL'

GO

Which extended stored procedure...