Anoo S Pillai (3/13/2014)

---

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

Same here.

How did I miss that?! the database level.:hehe:

sestell1 (3/14/2014)

---

OCTom (3/14/2014)

---

Koen Verbeeck (3/14/2014)

---

Richard Warr (3/14/2014)

---

Same here...

Definitely.

pmadhavapeddi22 (3/12/2014)

---

Thanks for the question.

You have given a hint in QOD to select one option out of 3.

The above hint tells that database and...

😀

j.green (3/11/2014)

---

free_mascot (3/11/2014)

---

Yes, initially I have drafted the question straight forward but it looks very simple. Deliberately make it complicated by tricky language to make challenging.

Usually everyone knows correct...

🙂

First explanation in QotD since quite long time without a reference!

From my previous hands-on experience, the correct answer should be "View Definition must be granted in each database". and by the way that`s the highest percentage answer.

Neither did I.

Too easy, no need even to run the code this time 🙂

Interesting question and discussion.

Nevyn (3/5/2014)

---

Koen Verbeeck (3/5/2014)

---

Interesting question, but I do not agree entirely with the answer.

Setting the commit size to a lower value will commit batches before the entire load is done....