• 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