Microsoft KB Archive/226501

= Donnerstag (Thursday) Does Not Appear in German Version of Weekly Reports =

Article ID: 226501

Article Last Modified on 5/8/2002

-

APPLIES TO


 * Microsoft Site Server 3.0 Standard Edition

-



This article was previously published under Q226501



Note: The information in this article applies to the German version of Site Server 3.0.



SYMPTOMS
When you use the German version of ReportWriter, all Chart types with the weekdays on the (x) axis do not show "Donnerstag" (Thursday).



CAUSE
In MSUsage.mdb the Weekday field is defined as char(9), which does not contain enough room for "Donnerstag."



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

219292 How to Obtain the Latest Site Server 3.0 Service Pack



WORKAROUND
To work around this problem, change the MSUsage.mdb database to have char(10) for the Weekday field. Databases created from now on will work correctly.

German users can run the following SQL Server script to upgrade existing SQL Server databases: CREATE TABLE tblRefWeekday(WeekdayID Int IDENTITY, WeekdayName char (10) NULL)

Set Identity_Insert tblRefWeekday ON

INSERT INTO tblRefWeekday(WeekdayID, WeekdayName) SELECT WeekdayID, WeekdayName FROM tblReferenceWeekday

Set Identity_Insert tblRefWeekday OFF

Update tblRefWeekday SET WeekdayName = 'Donnerstag' WHERE WeekdayName = 'Donnersta'

DROP TABLE tblReferenceWeekday

EXECUTE sp_rename tblRefWeekday, tblReferenceWeekday

ALTER TABLE tblReferenceWeekday Add CONSTRAINT xWeekdayID PRIMARY KEY CLUSTERED (WeekdayID)



STATUS
This problem was first corrected in Site Server 3.0 Service Pack 3.

Additional query words: hotfix hot fix qfe quick engineering patch

Keywords: kbbug kbfix KB226501

-

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

© Microsoft Corporation. All rights reserved.