Cannot alter the user 'dbo'. (Microsoft SQL Server, Error: 15150)

To resolve the below issue: Cannot alter the user 'dbo'. (Microsoft SQL Server, Error: 15150)

 FIX: If he is already mapped as a database owner, first we need to change the database owner to another user. Then afterwards we are able to grant him individual permissions as needed...

 Thanks,
Satish Kumar.

Upgrade edition in SQL Server

Hi All, Some times we are in the situation of Upgrading the current version of SQL Server to Different versions.. like Developer to Enterprise. During this scenario, the below links would be help full with great charm.....! Upgrade from SQL Server Developer to SQL Server Enterprise is supported: http://msdn.microsoft.com/en-us/library/ms143393.aspx How to: Upgrade to a Different Editions of SQL Server http://msdn.microsoft.com/en-us/library/cc707783.aspx Thanks, Satish Kumar.

[264] An attempt was made to send an email when no email session has been established

The following error message found in the SQL Agent logs:

Message: [264] An attempt was made to send an email when no email session has been established

This is known issue and workaround provided as below:

• right-click on SQL Server Agent and select "Properties."
• Click "Alert System"
• Unclick "Enable mail profile"
• Right-click SQL Server Agent again and select "Properties."
• Click "Alert System"
• Re-click "Enable mail profile"
• Click "OK"

After performing the above actions.. to take affect please restart the SQL Agent:
• Restart SQL Server Agent

Please let us know your comments…

Thanks,
Satish Kumar.