There is a system stored procedure called XP_SendMail. I think that there is some configuraition that needs to be done on the server to get this to work.

Look at this in the SQL help file for more information.

>On data change in a table I wish to send a message(as the one we send through the enterprise manager) to a connected user through a trigger. How do i programatically write it in a trigger. Need this urgently.Please help
>
>Thank you
>Neerja