Thanks for the info! Great stuff!

So if I want to implement this on another databases, I would have to create the stored procedure in each database and then sign the procedure with the cert correct?

Also...

To recap, when dealing with clusters – sometimes it is helpful to review the issue from two vantage points – the Windows cluster (2003/2008 or whatever version will be running...

I was able to resolve this by following the steps listed on the pages below. DTC for SQL Server should be a clustered resource and be on a seperate...

Did you take a backup of the databases before using the tuning advisor? Sometimes it creates hypothetical indexes that kill your performance. If you have a backup...

I think you have to make it a sql agent operator instead of sql agent user.

In Visual studio use the Transfer login task and set copy sids = true. It is under Integration Services project.

what about "sp_who2 Active" or the blocked process report?

Try changing the owner of the job to a login that has sysadmin rights. It may be because your SA password expired

Check out Ola's Maintenance Script. I think it is better than MS maintenance plans.

http://ola.hallengren.com/

Could be memory and it could be because the databases are on C:

Can you move the log files to another drive? What is your total server memory? Also how...

You can use the transfer login task in visual studio (Integration Services project) and set CopySids = true.

You could probably run profiler and select some of the "Error and Warnings" events and see what it turns up. I used this before in a similar situation.

Are you going to keep the same IP? Check out the following article

http://msdn.microsoft.com/en-us/library/ms143799.aspx

Just a suggestion on step 3 i've found that using the transfer login task and setting copy sid's = TRUE is easier if you have multiple logins to copy.