bsr.anwar (5/8/2014)

---

I created the trigger successfully but when I tried to update the table the query doesn't execute it prints out

error stating that

Msg 15281, Level 16, State 1, Procedure xp_sendmail, Line 1

SQL Server blocked access to procedure 'sys.xp_sendmail' of component 'SQL Mail XPs' because this component is

turned off as part of the security configuration for this server. A system administrator can enable the use of 'SQL

Mail XPs' by using sp_configure. For more information about enabling 'SQL Mail XPs', see "Surface Area

Configuration" in SQL Server Books Online.

Any help would be more appreciated am beginner to sqlserver