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