RATE THIS ANSWER
0
Click to Vote:
- 0
0
Last Answered:
Jul 20 2008 10:32 AM GMT
by Mrdenny 
41270 pts.
In SQL Server 2005 you want to use Database mail not SQL Mail. SQL Mail is the old mail setup which uses Outlook to send the email, and works much better with Exchange than POP3. Database mail uses SMTP to send the emails.
The easiest way to send email is via the sp_send_dbmail procedure in the msdb database. This way you can pass in a large number of parameters to have it send what you need it to.
Out of the box there is no way to send an SMS message. If you cell phone has an email address you can send to that email address. Normally it's your cell phone number @ your cell provider.
SQL Server 2005, SSIS, SQL Mail, SQL Server Integration Services
How to sent SQLMAIL in SQL Server 2005, through SSIS job, when my particular field is updated in database, can we sent SMS also through the SSIS script. 
