Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««12

SQL 6.5 and Y2K Expand / Collapse
Author
Message
Posted Friday, August 13, 2010 5:19 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Wednesday, December 3, 2014 8:17 AM
Points: 2,917, Visits: 2,537
Had to really dig through the cob webs on this one. Great piece of trivia

Steve Jimmo
Sr DBA
“If we ever forget that we are One Nation Under God, then we will be a Nation gone under." - Ronald Reagan
Post #968798
Posted Friday, August 13, 2010 6:59 AM


UDP Broadcaster

UDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP Broadcaster

Group: General Forum Members
Last Login: Friday, December 19, 2014 8:20 AM
Points: 1,490, Visits: 1,060
Study the past if you would divine the future. ~Confucius
Post #968873
Posted Friday, August 13, 2010 7:21 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Today @ 9:33 AM
Points: 1,832, Visits: 6,650
wware (8/13/2010)
Study the past if you would divine the future. ~Confucius


Good point.
I'll bookmark this page in readiness for 2100
Post #968899
Posted Friday, August 13, 2010 7:34 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Thursday, December 18, 2014 8:20 AM
Points: 985, Visits: 1,842
Come on -- historical questions can be fun, even if they don't mean anything about today's environment!

And good lord, I got it right because I did have to deal with that once upon a time. Supported an app that needed Y2K upgrades in those days, so I pretty much memorized all of the core MS Y2K stuff for things like Office and SQL Server that I interacted with.
Post #968914
Posted Friday, August 13, 2010 8:29 AM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Thursday, July 17, 2014 10:56 AM
Points: 3,924, Visits: 1,607
I still had one production server which is still running on 6.5 version and one on 7.0 version. Still, HR dept. wants to keep their data in 6.5 only.

I call it Jewel in the Crown as its one between 29 servers on 2005 and 6 on 2008 version.


SQL DBA.
Post #968971
Posted Friday, August 13, 2010 8:51 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Today @ 9:13 AM
Points: 1,676, Visits: 1,761
Nice question, thank you. I did not have to work with 6.5, because at the place of my employment we did not use SQL Server until, according to Microsoft developers, last line of Sybase code was removed from the product (thus giving birth to 100 percent Microsoft SQL Server 7 and initiating the party to celebrate the event). What I find amazing is that it is still easy to find some documentation about it. Here is the quote from TechNet Library -> TechNet Archive -> The Mole: Inside Microsoft -> The Mole # 5:

Yes, yes, yes, you can apply Microsoft SQL Server 6.5 Service Pack 5 to the Microsoft Small Business Server to make it fully Y2K compliant. While versions of SQL Server 6.5 SP2, SP3, and SP4 are compliant with minor issues, SP5 should provide complete adherence to our Y2K standards. This being the case, you can tell your clients a dumb joke (A man walked into a bar. Ouch!) Or simply urge them to have a nice day.


Oleg
Post #969005
Posted Friday, August 13, 2010 9:07 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Friday, April 25, 2014 8:31 AM
Points: 513, Visits: 430
cengland0 (8/13/2010)
Although I did get the answer right, I had to pick the closest response to the correct answer.

Technically, it was version 6.50.339 that fixed the Y2K issue. Then, Service Pack 5 came out (version 6.50.415) which was defective and you shouldn't have used it. Then, Service Pack 5a (version 6.50.416) released.

So, you could have fixed the Y2K problem before the release of SP5a if you installed the "Y2K" hot fix to the 6.50.281 (SP4) or 6.50.297 versions.


Do we have a quorum in the forum to recommend awarding @cengland0 an extra point?
Post #969018
Posted Friday, August 13, 2010 2:19 PM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Friday, February 4, 2011 7:20 AM
Points: 977, Visits: 1,499
rjv_rnjn (8/13/2010)
cengland0 (8/13/2010)
Although I did get the answer right, I had to pick the closest response to the correct answer.

Technically, it was version 6.50.339 that fixed the Y2K issue. Then, Service Pack 5 came out (version 6.50.415) which was defective and you shouldn't have used it. Then, Service Pack 5a (version 6.50.416) released.

So, you could have fixed the Y2K problem before the release of SP5a if you installed the "Y2K" hot fix to the 6.50.281 (SP4) or 6.50.297 versions.


Do we have a quorum in the forum to recommend awarding @cengland0 an extra point?
That depends on whether he remembered it or if he researched it. If he researched it, then he definitely gets an extra point. If he merely remembered it, then all he gets are the points we will be removing from all who thought this QotD was POINTless.


Tom Garth
Vertical Solutions

"There are three kinds of men. The one that learns by reading. The few who learn by observation. The rest of them have to pee on the electric fence for themselves." -- Will Rogers
Post #969264
Posted Monday, August 16, 2010 12:42 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Monday, December 1, 2014 7:30 AM
Points: 2,128, Visits: 5,565
CirquedeSQLeil (8/13/2010)
I actually remember this one. Thanks for the question. Would you believe that there are still some installs of 6.5 out there in the world?


5 years ago I was working at a company that I’ve found one SQL Server 6.5. Wonder if they still have it

Adi


--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
Post #969574
Posted Monday, August 16, 2010 7:13 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Friday, December 19, 2014 1:07 AM
Points: 1,208, Visits: 1,587
I remembered this one. Y2k Seems like a lifetime ago now!
Post #969748
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse