Viewing 15 posts - 31 through 45 (of 54 total)
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...
________________________________________________________
If you set out to do something, something else must be done first.
September 23, 2013 at 4:05 am
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...
________________________________________________________
If you set out to do something, something else must be done first.
September 23, 2013 at 3:34 am
Pavel Bakunovich (9/20/2013)
Dscheypie (9/20/2013)
Because in the first try I thought that the numeric data type...
________________________________________________________
If you set out to do something, something else must be done first.
September 20, 2013 at 6:59 am
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...
________________________________________________________
If you set out to do something, something else must be done first.
September 20, 2013 at 1:50 am
palotaiarpad (9/19/2013)
Good question! Learned something. Parsing does not set initial values! 🙂
+1
________________________________________________________
If you set out to do something, something else must be done first.
September 19, 2013 at 4:33 am
Well, and I failed to see something troublesome and answered correctly accidentily...
For me this question was therefore... ...welllll...
________________________________________________________
If you set out to do something, something else must be done first.
September 18, 2013 at 10:46 am
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...
________________________________________________________
If you set out to do something, something else must be done first.
September 18, 2013 at 10:44 am
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...
________________________________________________________
If you set out to do something, something else must be done first.
September 17, 2013 at 8:40 am
timothys (5/9/2013)
________________________________________________________
If you set out to do something, something else must be done first.
September 17, 2013 at 8:03 am
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...
________________________________________________________
If you set out to do something, something else must be done first.
September 17, 2013 at 7:42 am
Old fashioned:
SELECT value, MIN(t_stamp)
FROM @t
WHERE value IN
(
...
________________________________________________________
If you set out to do something, something else must be done first.
September 17, 2013 at 4:12 am
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...
________________________________________________________
If you set out to do something, something else must be done first.
September 17, 2013 at 3:56 am
*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...
________________________________________________________
If you set out to do something, something else must be done first.
September 17, 2013 at 3:39 am
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...
________________________________________________________
If you set out to do something, something else must be done first.
September 16, 2013 at 8:45 am
Hugo Kornelis (5/6/2013)
________________________________________________________
If you set out to do something, something else must be done first.
September 16, 2013 at 5:01 am
Viewing 15 posts - 31 through 45 (of 54 total)