I realize that there is an integrated email notification system in SQLServer, where I can configure it to send an email using my organization's Exchange server.
I want to use that to send email on the event that certain data is added, for example if I have a table with a column called 'error no' in it; I want to be notified via email when a certain error no. is being added.
e.g. if error no is 5, I want to be sent an email via the notification system. If the error no is 4, then insert it to table with no notification.
I would love to be able to do it without writing any stored procedure or T-SQL, but if I have to, then I have no problem doing it.
Thank you guys.