467,917 Members | 1,342 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 467,917 developers. It's quick & easy.

Please Assist...SQL Server 2005 New Line in Text

Hi there.I have currently written an e-mail notification using sql server 2005, the problem however is leaving a line after each section of data is displayed in the mail....i have tried the following but it does not work...the stored proc runs as a job, and there is quite alot of data to be sent as a report....How would i make provision for this??...Thanks in advance.....

Select @Mess = @Mess + 'Host Name : ' + @StationName + '..'
+ CHAR(13) + CHAR(10)
+ 'OS: ' + @OperatingSystem + '..' + CHAR(13) + CHAR(10)
+ 'OS Ver: ' + @Version + '..'+ CHAR(13) + CHAR(10)

Above is a piece of code i am using....
Sep 19 '08 #1
  • viewed: 2743
Share:
1 Reply
ck9663
Expert 2GB
Send it as HTML. You'll have more flexibility then.

-- CK
Sep 19 '08 #2

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

3 posts views Thread by Kris van der Mast | last post: by
3 posts views Thread by Cristina | last post: by
1 post views Thread by Brad Isaacs | last post: by
4 posts views Thread by Brad Isaacs | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.