FIX: SQL Server Date May Cycle to Start Date After 50 Days
PSS ID Number: Q111961 Article last modified on 08-28-1995
4.20 4.21
WINDOWS
The information in this article applies to: |
- Microsoft SQL Server, version 4.2 and 4.21 |
BUG# NT: 677(4.2)
SYMPTOMS
The internal date kept by SQL Server may cycle back to the start date if the server is run continuously for 50 days or more. This problem affects entries in the errorlog as well as the Transact-SQL GETDATE() function. After 50 days, the date kept by the SQL Server may revert to the date on which the server was started and begin incrementing again.
WORKAROUND
Stop and start the SQL Server at least once every 50 days to retrieve the system date from Windows NT.
STATUS
Microsoft has confirmed this to be a problem in Microsoft SQL Server version 4.2. This problem was corrected in SQL Server version 4.21. For more information, contact your primary support provider.
Additional reference words: 4.20 4.21 Windows NT KBCategory: kbbug 4.20 kbfix4.21 kbother KBSubcategory: SSrvWinNT
=================================================================
Copyright Microsoft Corporation 1995.