+1

Stewart "Arturius" Campbell (4/14/2014)

---

Good question, thanks Andy

almost tripped up, but remembered that databases is a system view, in the sys schema, not dbo.

The only way to reflect it in the...

Good question! had to do some R&D to find out the correct answer. And here is a good reference for the same subject:

http://www.sqlservercentral.com/blogs/steve_jones/2013/12/16/symmetric-keys/

Tony Bater (4/11/2014)

---

I am happy to say I got this right, but not so sure about the reason!

I didn't know the answer (so learned something here, and that's good), but...

Same here +...

I know this CHAR(13) + CHAR(10) method based on a painful previous experience 🙂

Never used this feature NOEXEC before, didn`t find the need to.

Interesting question, thanx 4 sharing 🙂

+1

Uwe Ricken (4/2/2014)

---

With respect - I know that preparation of a QoTD can be quite tricky and time consuming but this QoTD has the same problem as the last one;...

+1 agree!

Stewart "Arturius" Campbell (4/4/2014)

---

Interesting question, thanks.

I have never found the need to have more than one distributor per instance of SQL server, but good to know that it is possible.

radek.hruby...

Me neither, but very interesting QotD!

Glad to be part of the 17% 🙂

I think this part of the explanation is enough to end this debate.

'If 'king_login' is a member of sysadmin fixed server role table would be created under schema dbo, other...

Thanks 4 the easy 7 Pts. yet some fall for April fool 😀