So that's two votes for CU7. Thanks, guys.

James, did you apply the CU just to have a recent update, or were there specific issues that CU7 was intended to...

Service Packs are cumulative, so you should be able to just install SP2 w/out first installing SP1.

However, SP2 had some issues with maintenance plans, so if you use them you...

I wouldn't mind seeing it; our DB didn't appear to be compromised, but I'd be interested in your approach.

OK, thanks for the confirmation. I kind of figured that's what it was, but this is the first time I've ever seen one as it's happening (as opposed to...

I think everyone can agree that happy users are the goal (if you're a service provider, or a goal if you sell software), and that we sometimes need to remind...

kerry.corcoran (4/9/2008)

---

Windows Server 2003R2 w/ Sp2

SQL 2005 w/ Sp2

...

Is there a way to create a Maintenance Plan file or script that I can save and just add back to the...

Thanks for the info; this will save me some time. ...

In SQL 2005, SQL Mail (which I believe is equivalent to the way SQL 2K sends email) uses an Exchange profile, which is what allows it to talk to Exchange...

You might start by looking at the Database Mail Profile used by SQL Agent (Agent Properties --> Alert System). Change it to use your default global mail profile and...

I don't have an answer to your initial problem,...

The last time I did this I only had two issues.

One was a Reporting Services setting that didn't get updated by the RS Configuration wizard (I had to manually update...

There's also a stored procedure you can use to script logins from the old server that you can then run on the new server. It preserves SIDs and passwords...

Try using the "with log" option when you raise the error, e.g. "RAISERROR (50001, 16, 1) WITH LOG".  I don't remember exactly why it works, but this seems to be...

Finally figured out how to delete the old maintenance plans as well.  I used BI Dev Studio to export .dtsx package files from SQL Server to a local drive.  Then...

Never mind on the Reporting Services connection via SSMS.  I had to modify the UrlRoot setting in the RSReportServer.config file, as per this article: http://technet.microsoft.com/en-us/library/ms345235.aspx (entitled "Renaming a Report Server...