FIX: Carriage Return/Line Feed Is Not Correctly Written in Errorlog (197564)

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.