August 29, 2003 at 8:17 am
This is a trick question. Not all users are disconnected. Only the unqualifed users are after 30 seconds.
September 1, 2003 at 8:00 am
This was removed by the editor as SPAM
September 2, 2003 at 8:43 am
This is not a trick question. "Everyone" is not disconnected. The issuer of the ALTER DATABASE statement is not disconnected. The "answer" is incorrect. The correct answer should be #1. The database is placed into single user mode after 30 seconds.
September 2, 2003 at 10:44 am
There are a couple of threads on this question with many of us contesting the reported correct answer.
What is the outcome of this dispute? I think those of us who chose answer (1) should be credited with a correct answer.
Brian
September 3, 2003 at 2:16 am
Hi Brian,
quote:
What is the outcome of this dispute? I think those of us who chose answer (1) should be credited with a correct answer.
that never worked before on other critical questions
Cheers,
Frank
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
September 3, 2003 at 11:35 am
The proposed answer is the best choice. It does disconnect all users connected to the database which is being ALTERed. However, the wording would be more accurate, if it stated ' everyone connected to the database being altered (NOT CONNECTED TO THE SERVER)...'
IS THIS ADDITIONAL WORDING NECESSARY???
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply