Thanks for the response, Steve. I'll just use the general search again, then.

As far as question # 1 goes, make sure you download the errata for the book (regardless of version) before studying. Every version of the book has its...

FORFILES?

I haven't heard of that command. It works in the command shell?

To address the original question (though xp_cmdshell can be a major security hole)...

-- This code removes the previous day's backup from this folder

--BIG NOTE: This code is dependent on the...

Well, I updated my Batch size and Max Commit to 10000 and set my sources as queries. Started the run about 1 & 1/2 hours ago and already I...

I am filtering in the source by Deselecting all the columns. DIdn't think about the effect that would have... I should probably change that to a query instead.

I did...

Microsoft doesn't usually tell how they score the tests, but 700 or more has to be the total score you get in order to pass (I believe).

Used to be you...

Well, I passed. Should have rescheduled though. I hurt my back a few days before the exam, so didn't do as well as I wanted to because all...

Timothy,

You have a lot of good points. Unfortunately, per the privacy policy at my workplace, I have to inform X number of people to get the request signed off...

There should be another thread in the Cerification forum about the Second Shot thing.

Basically, there are certain times where MS gives you a code that you can take the test...

Yeah, I heard about that. (the UK data breach) OUCH!

Just finished reading everyone's responses. Everyone says they want it in writing, which is good, but my comment about the email request still stands.

Email is just too...

Posting this before I read the other replies...

First, how did I hear about this request from the CIO himself or via email?

If via email, I would be very suspicious and...

Go to microsoft's website and get the list of topics they cover. Then buy non-cert books that cover those topics.

Funny you should ask that... Just Tuesday, we had an article in the newsletter about that question.

See the below link:

http://www.sqlservercentral.com/articles/Administration/61591/