ada_caceres
asked on
sp_send_dbmail Limitations
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.
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;
TAkin@all.com; bill_davison@all.com",
@subject="Test Email",
@body="Let me(Ralph Hill) know if you get this"
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Sorry, everyone, These were all great suggestions. I tried everything posted but nothing worked. We're doing without this functionality.
ASKER
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;
TAkin@all.com; bill_davison@all.com',
@subject='Test Email',
@body='Let me(Ralph Hill) know if you get this'
When I did this the emails did not go out!