• I am new to SQL2005. I received the following error when execute the SP

    (3 row(s) affected)

    -- 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.

    -- 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 --

    -- ng 'SQL -- l XPs', see "Surface Area Configuration" in SQL Server Books Online.

    I check on the Help inside the SQL2005 and it warn us not to use the SQL_Mail but use the Database Mail instead and I have successfully configurated the SMTP database Mail. However, how can I change the SP to use the Database Mail instead of the SQL sendMail

    Thanks