Yes, I have a list of tables that I load into a recordset to pull from using an order by clause.

...in query workbench...

The question said "...in the Query Analyzer..." 

Steve, your right (I can admit it ).  I checked, it is by design.  SQL will set the recovery model of msdb to simple...

Well that question would need answers right...

1. I should have learned Oracle.

2. Nothing, what's playing on showtime?

3. The sun will come out...tomorrow.

4. Britney Spears is a man baby.

The Correct...

But while the answer sucked.. The question was valid.  The other three choices do not give you what you are looking for.  We know that...

umm

CREATE TABLE foo

(foo_id int identity,

 name varchar(10),

 age int)

insert foo(name, age)

select 'Foo', 20 union all

select 'Bar', 19 union all

select 'Hello', 20 union all

select 'World', 20

SELECT TOP 1 WITH TIES *

FROM foo

ORDER BY...

But as stated above, using the table foo and not people returns:

Not:

That sounds like another issue.

I see nothing wrong with this question.  Whether or not northwind or pubs should be there or not is not really at issue.  The question asked "Which of the following...

haha I was going to say the same thing. Oh well. 

No the default does listen on 33854.  Named instances listen on the first available after that.

So when would someone use this?

Good observation, you must own code reviews.

Not sure which article you are refering too, but check this one out just in case:

http://support.microsoft.com/default.aspx?scid=kb;en-us;301901

IT says that ,"Analysis Services uses TCP port 2725. For backward compatibility, Analysis Services...