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