Viewing 12 posts - 1 through 12 (of 12 total)
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\MSSQLServer\LoginMode
Honest mistake, but I want my honestly earned points back please.
August 25, 2004 at 5:31 am
Exactly. Thanks for the clarification.
July 30, 2004 at 7:57 am
I see where ansi_nulls is set to on by default in QA, which I never noticed before so thanks for that. However, I don't understand how QA would be running...
July 30, 2004 at 5:01 am
Yes, but I think we're talking about running this natively, such as through SQL Query Analyzer, right?
July 29, 2004 at 4:52 am
it makes sense only if ansi-null is set to on. If left to off, which is the database default, the answer is wrong, period.
July 28, 2004 at 6:21 pm
Luckily, I've been through enough of these erroneous QODs to know when to answer what the questioner wants rather than the real answer, so I got credit for this one.
However,...
July 28, 2004 at 4:44 am
I came here to complain as I always do about bad questions, and found that others had the same gripe already. I also want my points back on this one. ...
June 21, 2004 at 6:32 pm
I predict it's going to get pretty noisy over today's question. "Logging off" is contextual. The author of the question pulled that out of the below documentation, I would guess,...
May 27, 2004 at 10:58 pm
Why do you believe it would report no errors if you believe the syntax is incorrect?
May 10, 2004 at 9:35 pm
This is just wrong. BCP will fail using this syntax because "in" or "out" wasn't specified to dictate the BCP direction. The answer should be "BCP aborts with errors and...
May 10, 2004 at 9:33 pm
Also, the question asked for the most likely cause. Why would it be likely that someone went into the Model db and turned AutoClose on? Who would be that stupid...
April 8, 2004 at 10:31 pm
You bet your sweet #%$ their answer is incorrect. Its just plain wrong, no doubt about it.
November 21, 2003 at 6:19 am
Viewing 12 posts - 1 through 12 (of 12 total)