QOD 8/29

Question

QOD 8/29

HotGas

SSC Veteran

Points: 276
More actions
August 29, 2003 at 8:17 am

#106448

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

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

colt Old Hand Points: 317 More actions · Answer 1

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.

bhaberman SSC Veteran Points: 232 More actions · Answer 2

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

Frank Kalis SSC Guru Points: 111183 More actions · Answer 3

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]

wmp789 SSCarpal Tunnel Points: 4354 More actions · Answer 4

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???