2008. 12. 30. 16:10
데이터베이스 메일 셋팅 후.. 쿼리에서 발송시...
declare @body1 nvarchar(100)
set @body1 = N'Server :'+@@servername+ N' My First Database Email '
EXEC msdb.dbo.sp_send_dbmail @recipients='innoya@ynkjapan.co.jp',
@profile_name = 'Alert Mail',
@subject = 'My Mail Test',
@body = @body1,
@body_format = 'HTML' ;
declare @body1 nvarchar(100)
set @body1 = N'Server :'+@@servername+ N' My First Database Email '
EXEC msdb.dbo.sp_send_dbmail @recipients='innoya@ynkjapan.co.jp',
@profile_name = 'Alert Mail',
@subject = 'My Mail Test',
@body = @body1,
@body_format = 'HTML' ;
