20 isn't that many. You might spend more time figuring this out than just installing.

Lumigent, ApexSQL, LogPI, all have transaction log reader products.

I don't believe that you can do this.

We got lost in the employee shuffle at Microsoft when our old contact moved on and it took awhile for a new one to appear. I spoke with him last...

Why was it poorly worded? The snapshot agent is an agent needed for replication and the security that should be assigned is important. Reducing your attack surface is something that...

Red Gate software has a low cost compare tool, advertised in the footer, which is highly rated and there is a review on the site. ApexSQL also has one.

You should probably schedule the reindexes for very, very low use times or setup the application to try reconnecting after a few minutes.

The DTS copy Objects task might work. If you don't have a direct connection, create a small db, copy just those procs in it and send the (small) backup to...

Mike,

Apologies, a typo in the filename. It's fixed.

Bob is correct. The question is testing how you accomplish a task, which is what many examinations or interview questions will do. If you got this in a pre interview...

Sorry, that's the best answer of those that are available. You can always attach the errorlogs to the email that will contain the sqldiag output. The answer is correct, perhaps...

I tend to agree that MS hasn't introduced security very well into their products. There are some very smart people up there and I know many of them understand how...

That's strange. I'll have to give that a try, but I wouldn't expect that to be the problem.

Any query could peg your server at 100%. In fact, I've had lots of servers that would hit 100% for a minute or two.

Today there isn't anyway to determine this...