Microsoft KB Archive/308834

= FIX: Incorrect Display of Error Log in Enterprise Manager =

Article ID: 308834

Article Last Modified on 10/28/2003

-

APPLIES TO


 * Microsoft SQL Server 2000 Standard Edition
 * Microsoft SQL Server 7.0 Standard Edition

-



This article was previously published under Q308834



BUG #: 354811 (SHILOH_BUGS)

BUG #: 101900 (SQLBUG_70)



SYMPTOMS
SQL Enterprise Manager (SEM) incorrectly parses and displays SQL Server error logs that contain short stack dumps. SQL Server sorts the error log by date and SEM incorrectly interprets the date field for short stack dump lines; therefore, SEM sorts the error log incorrectly.



CAUSE
Short stack dump lines do not contain information that SQL Server can identify as date or source. However, SQL Enterprise Manager parses short stack dump lines as if they have the columns Date and Source, which results in the display of an error log that is very confusing to read and incorrectly sorted.



RESOLUTION
To resolve this problem, obtain the latest service pack for Microsoft SQL Server 2000. For additional information, click the following article number to view the article in the Microsoft Knowledge Base:

290211 INF: How to Obtain the Latest SQL Server 2000 Service Pack



WORKAROUND
To work around this problem, use a text editor to view the error log files that contain short stack dumps.



STATUS
Microsoft has confirmed that this is a problem in Microsoft SQL Server 7.0.

Microsoft has confirmed that this is a problem in Microsoft SQL Server 2000. This problem was first corrected in Microsoft SQL Server 2000 Service Pack 2.



MORE INFORMATION
To correct this problem SQL Server 2000 Service Pack 2 formalizes the format for the short stack dump lines in the SQL Server error log files, by preceding the lines in a short stack dump with an asterisk character (*). The SQL Server 2000 Enterprise Manager ignores lines that start with an asterisk and thus, it does not parse or sort lines from a short stack dump.

Additional query words: SEM EM

Keywords: kbbug kbfix KB308834

-

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

© Microsoft Corporation. All rights reserved.