USE Master
GO
sp_configure 'show advanced options', 1
GO
reconfigure;
GO
sp_configure 'Database Mail XPs', 1
GO reconfigure
GO
use msdb go
exec dbo.sp_send_dbmail @profile_name ='XX的邮件配置',
@recipients = 'XX@163.com', ----163的邮箱支持好些。QQ邮箱似乎不支持验证。
@subject = '数据库邮件测试',
@body = '这是一封测试邮件'
go
select * from dbo.sysmail_log go