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

    -- Msg 15281, Level 16, State 1, Procedure !!!!x!!!!p_sendmail, Line 1

    -- SQL Server blocked access to procedure '!!!!y!!!!s.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 -

    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