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




MS Sql Server LazyDBA home page