I have to agree with the correct answer on this one.  The question was related to Reporting Services and you can only generate one at a time.  The responses so...

Don't know what to say, it worked for me.

How about rights to create the file, you might need to determine what account is running the SPROC.  I would think that...

Chuck-

Check for C:\FILENAME.PDF, it should be there.

Regards,

Scott

I started using this for some basic reports that simplify my day.  I showed them to the boss and immediately he was wondering how far we can extend this capability.

I...

The questions asked to "fix the referencing aliases".  To me that does not imply dropping them.  I cannot agree with the answer based on the wording of the question.

Regards

Scott

I've gotten a lot of use out of "Professional SQL Server 2000 Programming" by Robert Viera.

Regards,

Scott

I actually hesitated before answering it because there had to be some kind of a trick to the question.

Regards,

Scott

I too chose "Error" and thought the correct answer was wrong.  But started to look at it closer and discovered that I was looking at the wrong tab. 

I find...

The Wrox book by Viera is the one I use.  I chose it because of recommendations and wasn't disappointed.

Regards,

Scott

Syntactically, the command is SET SHOWPLAN_XML  <-- Note the underscore.

Regards,

Scott

I almost answered 3 records, but I have burned on so many questions based on the wording, so I carefully reread the question.  Since the data is from the "People"...