BIG FAT HAIRY "DO-OVER"...completely worthless.  Pretty much time to look for a worthwhile SQL server site...

Oh...and at least get the justification for the answer correct, very shoddy...

Yep, we are all correct.  I finally found it and it is definitely the RSReportServer Configuration File where the SMTP server name/address is...

Actually folks, did anyone consider this statement...

"Once the benchmark employees begin to test the application, the orders table's identity column starts automatically numbering the primary key at the development environment's...

Actually, I chose sp_dropserver 'OldServerName' according to BOL, this SP is only used to modify the list of remote/linked servers on the local server.  There was no mention in the...

I'll take my two points now....

I'm with you all as well...from BOL:

"Logs a user-defined message in the Microsoft® SQL Server™ log file and...

I looked up the same BOL article but noticed it only had three of the six answers provided - and I noticed that the first one had been mis-copied into...

Thanks Phill - you da man!

In that case, we may well stay with exported .bas files.

One more for the "I got it wrong?!!" crowd. I've been doing a lot of DTS work and one of my biggest complaints is that you can accidentally save...

I'm guessing that we are dealing with a space limitation on the string that holds that error message and it looks like it backspaces over the tail of the string...

When you view the messages in the Job History window, are you checking the "Show Step Details" check box near the upper right of the window? Also do your...

Boo...Hiss!! Bad question. The Books Online sure seem to indicate the the FTP Task is for downloading however assuming sufficient rights, I could set the destination as another...

I should have had a cup of coffee before answering this question!! I did not notice the difference in wording between the newsletter and the browser window for this...

I also agree that the question was unclear. I tried accessing directories using UNC that I was certain the SQL Server account would not have access to and received...

I also agree that the answers to this question are poorly worded. The issuer of the command is not disconnected, therefore "everyone" is not disconnected. Answer (2) is...