Hi,
I've had this problem too. The way that worked for me was to create another variable, populate this with you variable then use that for the email e.g.
declare @Message varchar(500)
set @Message = 'This is an email confirmation that the following Server/s are now a part of Central Management Server. ' + @NewServerConnectionInfo +
'Thanks,
SQL SERVER'
EXEC sp_send_dbmail default,
@recipients='myemail@mydomain.us',
@subject='CMS on 007 Update',
@body=@Message
-------------------------------Posting Data Etiquette - Jeff Moden [/url]Smart way to ask a question
There are naive questions, tedious questions, ill-phrased questions, questions put after inadequate self-criticism. But every question is a cry to understand (the world). There is no such thing as a dumb question. ― Carl Sagan
I would never join a club that would allow me as a member - Groucho Marx