Hm, true. And: Yes, good question for the MS guys.

Apparently we cripple SQL Server by DENYing "guest" the access to msdb. So if one wants to avoid guests spying...

Interesting question. Yet I have another one:

Why not disabling "guest" for the master database?

I guess because SQL Server needs the access to the master database for extracting information from the...

Pavel Bakunovich (9/20/2013)

---

Dscheypie (9/20/2013)

---

I would have had slightly more troubles, if the INT data type would've been inserted first.

Because in the first try I thought that the numeric data type...

I would have had slightly more troubles, if the INT data type would've been inserted first.

Because in the first try I thought that the numeric data type would set the...

+1

Well, and I failed to see something troublesome and answered correctly accidentily...

For me this question was therefore... ...welllll...

Thank you for the explanation, Hugo!

Yet I totally disagree with you in one point: This question definitely is NOT useless!

I find it helpful to train me on being careful...

Oracle e.g. throws an error like "ORA-01773: may not specify column datatypes in this CREATE TABLE" in the corresponding "CREATE TABLE ... SELECT NULL...". So this will not help us...

timothys (5/9/2013)

---

That was a great question. Especially the similarity of the column names to demonstrate how easily a typo can be overlooked and still return what you expect (since...

Just to make sure: Did you install both Oracle drivers (32 and 64 bit) on the server that is running SSIS?

Make sure that it is definitely the correct driver...

Old fashioned:

SELECT value, MIN(t_stamp)

FROM @t

WHERE value IN

(

...

Interesting that you cannot change the visibility once you have objects referencing to it.

I understand that if visibility is ON and there are already non-CLR object referencing an assembly. Then...

*uuh*

Hi, Jeff,

my thanks to you for your great articles here on SSC as well as your comments outside.

And it was good of you to answer the idea regarding the use...

Oh, s***.

Is it a good question? Good question! For me the question was: What exactly is the question?!

Well, I already had troubles to solve the SQL arithmetic, I therefore wasn't...

Hugo Kornelis (5/6/2013)

---

What bothers me most about the point system is that it causes some people who feel a question was unfair to respond downright angry, demanding "points back" and...