I'm only familiar with creating a profile for each "from" address. It's pretty quick to script and the profiles are the best thing if you are sending multiple emails.

I put together this script a few weeks back when I had to set up a mass number of SQL 2008 instances, and use a standard convention for any emails...

Along the lines of Manu's suggestion...

Create a table that holds a single datetime value and run a job that updates that value every minute.

Create another table that will hold two...

Or install all the instances and then upgrade them all to SP2 at once.

Could you provide the contents of the log?

That's where I'm at, Cumulative Update Pack 2.

You can keep an eye on SQL updates (including service packs) at http://blogs.msdn.com/sqlreleaseservices.

If you are using any kind off RSS reader you can...

Looks to me as if you've not enabled SQL logins and are pretty much stuck at this point. Might be a reinstall.

I'm not sure that the client-side redirection is a part of the problem, that is usually related to redirecting folders to other locations (for example putting your "my documents" folder...

Could you retrieve the SID from AD and then see if there is a matching SID within sysxlogins, just as a confirmation of it not existing?

It very much depends upon the kind of workload that you are doing and how queries, inserts, updates, deletes are handled.

I had the same issue using a MAXDOP of 8....

There's no account that is a member of the administrator group on the machine that you could log in as?

It's going to be a bit intensive, but you can shrink the files with a DBCC SHRINKFILE

That sounds awesome, even though you lost me after the first paragrpah :w00t:

I would also check that DTC is enabled for network access and you allow transaction manage communication.

Litespeed is a very good product, but WAY expensive. There are a great many alternatives out there for a fraction of the cost, for example RedGates SQL Backup or Hyperbac....