What are you planning to do? You intend to have a working SQL cluster at the end?

One rather brute force method would be to write a cursor that inserts one record at a time and then capture the error/identify the record via try/catch.

I agree that some of the memorization type questions are a bit silly. I have the MCITP: Database Developer, MCITP: Database Administrator, and the pre-req MCTS. There were some questions...

This piqued my curiosity. I was able to reproduce and have a solution to offer you: Take it out of read only mode, then do the full back up. Then...

If you create the index, you may not need to break it up into smaller chunks. Creating an index on the id field will still improve response time, even with...

Develop a script (you can even get one from msdn, I think) which checks for fragmentation and only rebuilds the indexes that are necessary. This will not prevent the table...

Any reason why you cannot also create an index on table a, then drop it when you are done?

I have yet to take the 70-432 but I passed the 70-431 (SQL 2005) some years back. If it's anything like that exam, it will have a simulation along with...

Looks like it is because you are conditionally returning two different data types for the same field. Try casting the dates to varchars.

Also, there are several issues with your approach...

See if any of these tips help.

http://social.msdn.microsoft.com/forums/en-US/sqlsetupandupgrade/thread

/afe08496-eb31-4cb4-a45f-9eb671eacbd2/

Can you start the services from inside of Configuration Manager?

From BOL: "For each column, the statistic is printed in the form number(number)-number% or number(number). The first number refers to the number of seconds (for cpu_busy, io_busy, and idle) or...

So Configuration Manager shows no services listed, then? Do you see anything pertinent in eventvwr?

What SQL services are currently installed?

Usually means that ssms is waiting for the server to respond. It is not, in and of itself, a problem.