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

• Microsoft SQL Server version 6.5

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 version 6.5. This problem has been corrected in U.S. Service Pack 5a for Microsoft SQL Server version 6.5. For information about downloading and installing the latest SQL Server Service Pack, see http://support.microsoft.com/support/sql/.

For more information, contact your primary support provider.

Additional query words: sp sp5prodsql wrap wrapping wrapped SEM errorlog

Keywords          : SSrvErr_Log kbbug6.50 kbfix6.50.SP5 
Version           : winnt:6.5
Platform          : winnt 
Issue type        : kbbug 

Last Reviewed: May 4, 1999