Line Feed and Caradge Return in SQL Statement
Posted on 2004-09-01
I am using 2 SQL Servers, 1 is a Production Server and 2 Live database server. I use to insert records in Server 1 and while inserting through VB code i generate an email that gets the data to Server 2 and inserts values there too. Now the problem is when Outlook at Server 2 gets the mail and try processing the mail from SQL Mail feature it gives error. When I use that statement and try to debug and check the hex value at DOS prompt the line where the error was given, contains line feed and caradge return, and that makes SQL Server 2 not to recognize the Query properly. Is there any feature/solution to overcome this problem.