Well I am having a bit of a problem with the above...
Basically I am trying to send an email to multiple recipients, should be easy right (just use a ";"); ummmm, no....
If I run this:
EXEC msdb.dbo.sp_send_dbmail
@profile_name = 'local'
,@recipients = 'test1@test.com;test2@test.com'
,@subject = 'test'
only test2@test.com receives an email
If I run this:
EXEC msdb.dbo.sp_send_dbmail
@profile_name = 'local'
,@recipients = 'test1@test.com,test2@test.com'
,@subject = 'test'
only test1@test.com receives an email
My SQL Server version:
10.0.1600.22
RTM
Developer Edition
Any ideas..........