Sorry I'm late to the party, but,

sys.syslockinfo  does not exist in SQL SERVER 2000.

Use master.dbo.syslockinfo in place of sys.syslockinfo to get the script to work in...

DO NOT QUESTION THE MICROSOFT!

PAY NO ATTENTION TO THE MAN BEHIND THE CURTAIN.

Resistance is futile.

You will be assimilated.

Am I the only one that sees this as a perfect definition for "Accident Waiting To Happen"?

D'oh. Thanks for the explanation.

I picked the correct answer of 5 hours.

But got...

Sorry - you were wrong

Correct answer:

5 hours is returned by the SELECT statement, The create table statement succeeds

I'm running SQL Server 2000.

This code throws an error like the one for version 2005.

This is a poorly worded question.

It does not state the conditions of the question.

Tried it on my 2000 server.

Opened a Query Analyzer window.

Entered both lines.

Pressed F5 to run.

I...

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