sending mail from Sqlserver2005

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SQL Server Administration (2005)

sending mail from Sqlserver2005

Author

Topic

mike123
Master Smack Fu Yak Hacker

1462 Posts

Posted - 2007-06-29 : 09:52:45

Hi,

I have 0 experience with SQLMail, and I don't want to go too deep into it as I already am trying to learn more than I can with the other parts :) I'm wondering, is there an easy way to have SQL Email me when anything strange happens with the SQL server? It would be awesome to get alerts to my phone.

Thanks very much
mike123

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2007-06-29 : 12:53:48

You will definitely need to define strange.

With SQL Server 2005, we now use Database Mail instead of SQL Mail.

Tara Kizer
http://weblogs.sqlteam.com/tarad/

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-06-30 : 20:57:13

You can set alerts in sql agent, it can send message with sql mail or db mail.

LA768
Starting Member

9 Posts

Posted - 2007-06-30 : 23:22:04

Before you can set up an alert, you would need to enable SQL Mail in SQL Server 2005.
By default, it is disabled as SQL Server 2005 now use Database mail due to security reasons.

If you wish to enable SQL Mail, you would need to go to SQL Server 2005 Surface Area Configuration
then choose, Surface Area Configuration for Features. Under "Database Engine", you will see
SQL Mail, make sure that is checked.

Then, you would need to set up the "Profile". Login to your Database Engine and under
Management> Legacy > you will see SQL Mail. Right click and then choose Properties.
You will see "Profile Name". This is the profile name that your Outlook client is
using. Click on "Test" upon entry and if all goes well you should be good.

Then you can set alerts.
You can also now use xp_sendmail instead of sp_send_dbmail.

Good Luck
Larry

Larry :-)

NeilG
Aged Yak Warrior

530 Posts

Posted - 2007-07-01 : 18:09:23

with sql 2005 you can set up performance alerts that email you for user-defined reasons like the tran log is about 70% full etc

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources