<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Recent Posts
Recent Posts
Popular Topics
Popular Topics
Home
Search
Members
Calendar
Who's On
Home
»
Article Discussions
»
Article Discussions by Author
»
Discuss content posted by Henrico Bekker
»
SQL 6.5 and Y2K
20 posts, Page 2 of 2
««
1
2
SQL 6.5 and Y2K
Rate Topic
Display Mode
Topic Options
Author
Message
sjimmo
sjimmo
Posted Friday, August 13, 2010 5:19 AM
SSCrazy
Group: General Forum Members
Last Login: Wednesday, May 22, 2013 7:15 AM
Points: 2,865,
Visits: 2,467
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
Rose Bud
Rose Bud
Posted Friday, August 13, 2010 6:59 AM
Ten Centuries
Group: General Forum Members
Last Login: Thursday, May 16, 2013 9:42 AM
Points: 1,072,
Visits: 1,026
Study the past if you would divine the future. ~Confucius
Post #968873
Toreador
Toreador
Posted Friday, August 13, 2010 7:21 AM
Ten Centuries
Group: General Forum Members
Last Login: Friday, May 17, 2013 9:52 AM
Points: 1,356,
Visits: 4,761
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
jeff.mason
jeff.mason
Posted Friday, August 13, 2010 7:34 AM
SSC Eights!
Group: General Forum Members
Last Login: Monday, May 06, 2013 6:51 AM
Points: 989,
Visits: 1,790
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
SanjayAttray
SanjayAttray
Posted Friday, August 13, 2010 8:29 AM
Hall of Fame
Group: General Forum Members
Last Login: Friday, March 15, 2013 2:43 PM
Points: 3,924,
Visits: 1,554
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
Oleg Netchaev
Oleg Netchaev
Posted Friday, August 13, 2010 8:51 AM
SSCommitted
Group: General Forum Members
Last Login: Tuesday, May 21, 2013 10:53 AM
Points: 1,662,
Visits: 1,709
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
rjv_rnjn
rjv_rnjn
Posted Friday, August 13, 2010 9:07 AM
Mr or Mrs. 500
Group: General Forum Members
Last Login: Monday, February 25, 2013 12:52 PM
Points: 513,
Visits: 426
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
Tom Garth
Tom Garth
Posted Friday, August 13, 2010 2:19 PM
SSC Eights!
Group: General Forum Members
Last Login: Friday, February 04, 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
Adi Cohn-120898
Adi Cohn-120898
Posted Monday, August 16, 2010 12:42 AM
SSCrazy
Group: General Forum Members
Last Login: Wednesday, May 22, 2013 9:50 AM
Points: 2,019,
Visits: 4,923
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
Bex
Bex
Posted Monday, August 16, 2010 7:13 AM
Ten Centuries
Group: General Forum Members
Last Login: 2 days ago @ 7:57 AM
Points: 1,111,
Visits: 1,394
I remembered this one. Y2k Seems like a lifetime ago now!
Post #969748
« Prev Topic
|
Next Topic »
20 posts, Page 2 of 2
««
1
2
Permissions
You
cannot
post new topics.
You
cannot
post topic replies.
You
cannot
post new polls.
You
cannot
post replies to polls.
You
cannot
edit your own topics.
You
cannot
delete your own topics.
You
cannot
edit other topics.
You
cannot
delete other topics.
You
cannot
edit your own posts.
You
cannot
edit other posts.
You
cannot
delete your own posts.
You
cannot
delete other posts.
You
cannot
post events.
You
cannot
edit your own events.
You
cannot
edit other events.
You
cannot
delete your own events.
You
cannot
delete other events.
You
cannot
send private messages.
You
cannot
send emails.
You
may
read topics.
You
cannot
rate topics.
You
cannot
vote within polls.
You
cannot
upload attachments.
You
may
download attachments.
You
cannot
post HTML code.
You
cannot
edit HTML code.
You
cannot
post IFCode.
You
cannot
post JavaScript.
You
cannot
post EmotIcons.
You
cannot
post or upload images.
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
