If the solution from Abu Dina is oversimplified, below is a more practical solution.

SELECT GroupName, SUM(NumberOfCases) as NumberOfCases

FROM #TempTable

GROUP BY GroupName

UNION ALL

SELECT 'Grand Total' as GroupName, SUM(NumberOfCases)

FROM #TempTable

Are the backups of the other databases written to the same folder?

Does the SQL Agent service account has the correct permissions to that folder?

It is not possible to detach/attach a database from a higher version (SQL2008 R2) to a previous version (SQL 2008). You also can not restore a backup to a previous...

Can u give some more information? Perhaps add some samples to clarify your question?

I assume you have a table with a column with datatype BIGINT. You use that column...

The error message indicates the SQL Agent error logfile is locked by another proces. This proces could be for example an Anti-Virus application. When this error occurs you can use...

See if you are able to hold the last used report parameters in a table. For the next report read the parameters from the table and determine the new parameters...

Getting mountpoint info is a bit harder in older versions of SQL Server. I used to get the info by using XP_CMDSHELL and WMIC. I changed the output of WMIC...

The error message indicates problems connecting to the source. Do you see any errormessages in MySQL? Can you setup a monitoring in MySQL to record connections, connection-endings and connection-attemps?

You could...

A stored procedure cannot be changed without the ALTER PROCEDURE statement. Your statement the stored procedure "has changed itself" indicates someone executed code to drop/recreate or alter the existing stored...

First follow the advise given by Grant and Gail.

But also consider archiving some data. Does the business really need all the 400GB of data? Try to move parts of data...

double post

please only reply to http://www.sqlservercentral.com/Forums/Topic1523063-1550-1.aspx

When I read your posted error log, I see the following error:

MSI (s) (14:88) [10:06:28:569]: Product: Microsoft SQL Server Setup Support Files (English) -- Error 1402. Could not open key:...

In SQL Server you can see most of the connected application-names, but you cann't see if they connect through a DNS-alias or not. You have to look at the connection...

What happens when you recompile the query after it executed with slow response. Does that generate another queryplan once executed again? P.S.: don't update stats in between...

- look for blocking processes during the moments the stored procedure takes a long(er) time to complete.

- capture the actual query plan of the stored procedure for both executing times...