That is a matter of opinion. Yes, mixed mode can allow access to users without...

Is the maintenance plan always running during non-peak times, or are you running it around the same time frame that you are running checkdb manually? I am just wondering what...

I am not an expert on this, but I would think that when you create the Password field that it would be of a datatype like varchar with a limit...

I agree with Bru, but once the immediate emergency is resolved you should plan to move the database files off of the C drive. There is already enough I/O contention...

Indexes will not have to be rebuilt. Shrinkfile is only releasing white space that was reserved by the database but not actually used. The performance hit will come when the...

So, are you still having an issue connecting? Did you install the database engine server component? That is the only way you will be able to connect locally using the...

Make sure you are getting both the T-SQL commands and the stored procedures being run against the server.

If you haven't created any database objects such as user databases or logins yet, you can use the setup utility to restore the master database. You should not have to...

If the server has changed I would check with the Exchange admins to ensure that SMTP relaying is enabled for your box.

Is that the entire error from the log? I had a similar issue happen with an SCCM instance lately. It came down to a CLR function that was running out...

So what is the error message exactly that you are getting when you try and access the instance with the sa account? It could be that you are still in...

I am not sure if there is a way with T-SQL to write into Excel, but you can use a scripting language like VBScript or probably PowerShell to read from...

Yeah, it would probably be easier to create an empty database on the 2000 box and setup something like a DTS/SSIS package to have the data from the 2008 machine...

Seems like this was a bug back in SP2, but was patched in later versions. Without knowing any error details the symptoms sound similar. It may be a matter of...

I may not be clear on this, but it sounds like you have maint plan jobs running during maintenance windows. If that correct? Can you modify the jobs to not...