Problem

You configure SQL Server Maintenance Plan and set it to e-mail you when the job is complete. When you check the job history, you notice that it fails to send the e-mail and the following message is logged:

Could not generate mail report.An exception occurred while executing a Transact-SQL statement or batch.No global profile [...]

Problem

This problem usually happens when you move your SharePoint farm to a different database server using SQL Aliases. When you create the Session State Database in SharePoint, it creates a SQL Agent job called <DB Name>_Job_DeleteExpiredSessions. This job runs every minute to clean out the expired sessions from the database. Without it, your database [...]

Problem

We recently moved all our SharePoint databases to a new server. This morning I noticed that the new SQL server was reporting that one of the databases had a corrupted index.

Log Name:      Application
Source:        MSSQL$SP
Date:          2/01/2013 9:05:02 AM
Event ID:      8646
Task Category: Server
Level:         Error
[...]