I am actually more concerned about the distributor_admin being able to read all transactions that are sent through replication and including sensitive information in some of them because if...

You asked for the easiest way.  None of my users are going to know how to specify the port number, but it's extermemly easy for me to configure port forwarding...

Correct answer: You cannot do this as the sqldiag utility includes all error logs.

You cannot use sqldiag to accomplish this task.  You need to use enterprise manager to...

Actually this is not supported at all in SQL Server 2005, but will be in a later update.

you only NEED 7 ip addresses if you are running active/passive/passive

I have used this exact setup for a reporting server.  You only need to create a database view on the mirror to be able to use the data.  Creating a...

Even by your MSDN article you are completely wrong!

There is only one tempdb per server and the other three answers are all correct.  The two most important things...

Isn't it the other way around - a bookmark lookup is telling you that the query processor had to look up the row columns it needs from a table or a clustered...

You have likely exceeded the maximum int value of 2,147,483,647.

http://support.microsoft.com/default.aspx?scid=kb;en-us;Q307533

You stated that "if you're not paying for the class, it's illegal, and immoral".  Here in Wisconsin, since my taxes pay for the operation of the state university system, I have...

http://support.microsoft.com/kb/297248/EN-US/

Make sure you have applied SP3 to Analysis Services.  This is separate from the install of SP3 - you need to run the file Sql2kasp1.exe directly.  Look for this...