By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,575 Members | 1,948 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,575 IT Pros & Developers. It's quick & easy.

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

P: 18
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
Share this Question
Share on Google+
1 Reply

Expert 2.5K+
P: 2,878
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.