Microsoft KB Archive/197564

= FIX: Carriage Return/Line Feed Is Not Correctly Written in Errorlog =

Article ID: 197564

Article Last Modified on 3/14/2006

-

APPLIES TO


 * Microsoft SQL Server 6.5 Standard Edition

-



This article was previously published under Q197564



BUG #: 16769 (SQLBUG_65)



SYMPTOMS
In the SQL Server error log, there are some lines for which a proper carriage return/line feed (CRLF) pair is not correctly written when viewed in the Microsoft Notepad text editor. This can potentially hide some information from a browsing user.



WORKAROUND
To work around this problem, do one of the following:


 * Use Microsoft WordPad instead of Notepad. The best way to do this is to open the error log in Notepad first, select and copy all the text to the clipboard and then paste it into WordPad. You can also open the error log directly in WordPad, but this requires you to stop the MSSQLServer service first. -or-


 * Use the SQL Enterprise Manager to view the error log. To do this, start the SQL Enterprise Manager. On the Server menu, click Error Log. -or-


 * Use another tool, such as List.exe, to view the contents of the error log.



STATUS
Microsoft has confirmed this to be a problem in SQL Server 6.5. This problem has been corrected in Service Pack 5a for Microsoft SQL Server 6.5.For more information, click the following article number to view the article in the Microsoft Knowledge Base:

197177 INF: How to Obtain SQL Server 6.5 Service Pack 5a

For more information, contact your primary support provider.

Additional query words: sp sp5prodsql wrap wrapping wrapped SEM errorlog

Keywords: kbbug kbfix KB197564

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.