Donnerstag (Thursday) Does Not Appear in German Version of Weekly Reports (226501)
The information in this article applies to:
- Microsoft Site Server 3.0
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."
RESOLUTIONTo 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.
| Modification Type: | Major | Last Reviewed: | 5/8/2002 |
|---|
| Keywords: | kbbug KB226501 |
|---|
|