I meant to send an e-mail, but it was a syntax error on part. I was
quoting each recipient ('[Email address protected] instead of just quoting
the whole list of recipients ('[Email address protected]


-----Original Message-----
From: Jonathan Baker
[mailto:mssqldba-ezmlmshield-x93184217.[Email address protected]
Sent: Friday, September 28, 2007 1:28 PM
To: LazyDBA Discussion
Subject: RE: DB Mail question on SQL 2005

What are you using as a separator?

You can always send a test message to multiple recipients through SMS
and determine what is up.



-----Original Message-----
From: Theodore Andrew
[mailto:mssqldba-ezmlmshield-x16924291.[Email address protected]
Sent: Friday, September 28, 2007 12:41 PM
To: LazyDBA Discussion
Subject: DB Mail question on SQL 2005

All -

I'm trying to setup a job that will mail a few different recipients.
However when I execute the job with the 5 or so recipients, I get an
error message. If I just limit the message down to 1 person, it works
just fine. My syntax 'appears' to be correct, but then again I could be
missing something. Can someone offer opinions?

-----code------

exec msdb.dbo.sp_send_dbmail @body =Body of message, @subject = 'Subject
of message', @recipients = '[Email address protected] om'

----end---------






---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY To post a
dba job: http://jobs.lazydba.com To subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html





---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY To post a
dba job: http://jobs.lazydba.com To subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html


MS Sql Server LazyDBA home page