Hi ,
I am using SQL server 2008 and in need a help regarding beautifying a msg line that displays in Email body .can any one help me in doing that.
Below is the message line
@msg nvarchar(max)='The Certificate/Password for '+ISNULL(@cert, '') + ISNULL(@user, '')++' of '+@App+' on server '+@server+' is expiring on '+ Coalesce(Convert(Varchar, @date), '')