I get the following message with I execute the code belowl. How can I extend the 128 limit. I also get this massage when the @query is longer that 128!
Msg 103, Level 15, State 4, Line 2
The identifier that starts with 'Jon_Peters@Pall.com; Steve_Jordan@Pall.com; Brenda_Robinson@Pall.com;
Pat_Travis@Pall.com; Greg_McIntosh@Pall.com; David_Conn@P' is too long. Maximum length is 128.
exec msdb.dbo.sp_send_dbmail @profile_name="insqlmail",
@recipients = "bill_Peters@all.com; Jon_Jordan@all.com; Brenda_Ball@all.com;
Nat_avis@all.com; George_McIntosh@all.com; Bill_Conn@all.com;
@body="Let me(Ralph Hill) know if you get this"