Sql sending SMS or email, or launching an application.

[Sirag]

Hi all.. Please help me make SQL server, send alerts with special text, as SMS or email to a specified person whose phone or email are present in the database.The sending process should occur when the data related to this person is updated, or when his birthday is met for example(as a reminder). And how can SQL launch an application, for example vb.net or asp.net application as a responce for an event, alert, or job. AND Thanks before... Sirag..

[shm53]

Have you looked at SQL mail? There is a COTS package called Postie that will send mail too. SQL mail requires Outlook to be installed on the SQL Server. Check also DatabaseMail with SQL 2005