Is SQL 6.5 year 2000 compliant ?

[SeanJansson]

<br>
1. Can anyone tell me if SQL Server 6.5 is Y2K compliant?<br>
<br>
2. Is a specific patch required to make it so?<br>
<br>
Cheers <br>
Seán.

 

[Guest_imported]

[The following is an excerpt from the SQL Server FAQ available at <A HREF="

http://www.swynk.com/faq/sql/"

TARGET="_new">

http://www.swynk.com/faq/sql/</A>

]<br>
<br>
Is MS SQL Server Y2K compliant?<br>
That depends on what you mean by &quot;compliant&quot;. If you mean the base SQL functionality works as you would expect then yes, as long as you are using &quot;proper&quot; datetime formats then all versions of SQL Server perform correctly - if you are holding dates in char/numeric format, then it totally depends on how you are processing them, it is not an MS SQL Server issue. <br>
<br>
SQL Server does date-windowing for two digit dates. If you specify only the last two digits of the year, values less than 50 are interpreted as 20yy, and values greater than or equal to 50 are interpreted as 19yy. For example, if you specify 3, the result is 2003. If you specify 82, the result is 1982. You must type the century when the day is omitted or when you need a century other than the default.<br>
<br>
However, if you mean the whole of the MS SQL Server product set including all the gui tools, then there are a few non-showstopper problems that have been found. These are all documented at <A HREF="

http://www.microsoft.com/y2k"

TARGET="_new">

http://www.microsoft.com/y2k</A>

along with MS's stance and technical info on Y2K issues for all their products. The SQL 6.5 Y2K fix titles are also copied at the bottom of this note.<br>
<br>
These problems have been found, fixed and tested in SQL 6.5 and will be in Service Pack 5 when it is released. Before that a Y2K fix (build 339) can be obtained from MS PSS - however I would recommend waiting for SP5.<br>
<br>
<br>
SQL 1.x, 4.x and 6.0 are NOT being tested or certified by MS. They are unlikely to have any other problems than those found in the 6.5 product though, so if you can live with those (and most people can), then they should be ok. <br>
<br>
Vendor's certification should only be one part of Y2K testing anyway - the most important part is that YOU test your clients, servers, apps, databases, networks etc. in your production environment.<br>
<br>
------------------<br>
SQL 6.5 Y2K bug numbers and titles<br>
<br>
17458 Year 2000 Problem with Expiredate <br>
<br>
17937 Y2000, ExpireDate is not set correctly when year of 2000 used in DUMP DATABASE <br>
<br>
17947 RETAINDAYS: expired dump media can not be overwritten if current year is &gt;= 2000 <br>
<br>
17948 Dump db with RETAINDAYS during Y2000-9, EXPIREDATE will be set to NULL <br>
<br>
17997 Y2000: dump device dumped with expiredate set to &gt;=2000 can be override with init <br>
<br>
17661 Task Manager UI: one time task date\time spin box doesn't pick up 2/29/2000 <br>
<br>
18153 Web Assistant: Cannot use Year as 00 on Scheduling <br>
<br>
18170 Invalid Y2K dates are accepted with no error by sp_addtask <br>
<br>
18180 Invalid Y2K dates are accepted with no error by sp_purgehistory and sp_ updatealert <br>
<p>John Vogel<br><a href=mailto:john@computerwiz.net>john@computerwiz.net</a><br><a href=

http://computerwiz.net>ComputerWiz</a><br>

 

[SeanJansson]

<br>
Cheers John.<br>
<br>
We need to load the SP, then we'll be fine.<br>
<br>
Seán.<br>
<br>