QOD 29/08/2003

Question

Post reply

QOD 29/08/2003

Thierry_Bertin

Grasshopper

Points: 11
More actions
August 29, 2003 at 6:09 am

#160632

Hi,
I think the official response is not good,
because the answer 2 says ...everyone wil be disconnected...
and on the documentation about SINGLE_USER
[ ROLLBACK AFTER integer [SECONDS]
ROLLBACK AFTER integer SECONDS waits for the specified number of seconds and then breaks unqualified connections. Incomplete transactions are rolled back. When the transition is to SINGLE_USER mode, unqualified connections are all connections except the one issuing the ALTER DATABASE statement. ]....
[ all connections except the one ] is not equal to [ everyone ]
....
Cheers
Thierry
Edited by - Thierry_Bertin on 08/29/2003 06:10:56 AM

Thierry

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

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

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

Hi Thierry,

quote:
[ all connections except the one ] is not equal to [ everyone ]

I made the same mistake

Who is responsible for this one?

Cheers,

Frank

--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

Jim P. SSCrazy Eights Points: 8725 More actions · Answer 2

ALTER DATABASE Northwind

SET SINGLE_USER

WITH ROLLBACK AFTER 30 SECONDS

Did they change this in SQL2K from SQL7? I ran it against my SQL7 server and got the following message.

Server: Msg 156, Level 15, State 1, Line 2

Incorrect syntax near the keyword 'SET'.

----------------
Jim P.

A little bit of this and a little byte of that can cause bloatware.

jpipes SSChampion Points: 12230 More actions · Answer 3

quote:
ALTER DATABASE Northwind
SET SINGLE_USER
WITH ROLLBACK AFTER 30 SECONDS
Did they change this in SQL2K from SQL7? I ran it against my SQL7 server and got the following message.
Server: Msg 156, Level 15, State 1, Line 2
Incorrect syntax near the keyword 'SET'.

Yep, and the question did not specify. Caught me.

Edited by - jpipes on 08/29/2003 07:12:00 AM

dan_jf SSC-Addicted Points: 496 More actions · Answer 4

Seems to be a trend lately in the poor quality of questions! They seem to be more and more open ended and vague. I havnt bothered answering many of them lately!