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