BorderLayoutBoxedLayoutOpenLayoutMaximum textMedium textSmall text


Register
Thursday, September 02, 2010
MyStreamMinimize
Print  

Why People are still on SQL Server 2000

Posted by Jason on Tuesday, February 17, 2009 to SQL Server 2008
1295 Views | 7 Comments | Article Rating

I asked 1200 tweeple if and why they are still running SQL Server 2000. The results are interesting. It appear vendors *are* evil.


statisticsio: How many people are still running SQL2000? Why? When are you going to SQL2008? If not, why? No comments from the Oracle\MySQL pnut gallery.


jasoncrider: we are still mostly 2000. Biggest reason is training and money. We wouldn't be moving towards 2005 if I didn't push.
about 14 minutes ago
bofe: We're still running SQL2000 because a vendor's product won't work with 2005/2008.
about 14 minutes ago
Tim_Mitchell: Some apps still on SQL2K due to $%*! vendor requirements. Those that we fully control will be on SQL08 this yr or early next
about 24 minutes ago
nathanblevins: Not to mention that upgrading is a 'dark and scary place' for many folk who have not been keeping up w/ the Jones'
about 27 minutes ago
nathanblevins: My client still runs 2k on quite a few of their projects. Much like @wbm 's clients, they have no real need to change.
about 28 minutes ago
The_BORG: Legacy software still in use (at work). Lame. Yes I know.
about 32 minutes ago
SDyckes: still running production apps on 2000. Just like @tjaybelt, Devs have not made the step. Running reports on 2005 perfom incres
about 34 minutes ago
peschkaj: Only 2005 over here, moving to 2008 in a few months.
about 44 minutes ago
nelsonmichael: still on SQL 2000, waiting for IT to learn SQL 2005, little hope of SQL 2008 anytime soon
about 45 minutes ago
crisatunity: *throws peanut*
about 49 minutes ago
jmkehayias: only 2000 instances left here are because the apps won't support upgrade to 2005/2008.
about 50 minutes ago
wbm: i've got two customers still running sql2k. both have no pressing need to upgrade.
about 53 minutes ago
babylon78: Still running my SIS on 2000..mostly due to not having gotten around to upgrading yet. Smaller SQL Srv. are on 2005. no 2008
about 53 minutes ago
BrentO: we were at Southern because we had a slew of apps that we hadn't put on support, and our versions were only 2000-compatible.
about 53 minutes ago
tjaybelt: its been talked about, just never seriously put on table. now, entire system going Oracle soon. so no upgrade planned
about 53 minutes ago
tjaybelt: we have prod on 2000 still. 2005 dbs are in compatibility mode 80. dev has not proved move to 2005 or 2008 feasible yet.
about 54 minutes ago
CooperHawkes: Completely on SQL 2005, right now no plans to go to 2008 until the merger situation here is completed..
about 54 minutes ago
RalphMRivera: I'd be curious to see your results.
about 54 minutes ago
crypticscholar: I know one on 2K right now that is (hopefully) going to 2K8 next week.
about 55 minutes ago
statisticsio: How many people are still running SQL2000? Why? When are you going to SQL2008? If not, why? No comments from the Oracle\MySQL pnut gallery.
about 56 minutes ago

email it! |   |   |   |  | 
Permalink     7 Comments  

Rate this Post:
COMMENTS:

I love that peanut crack made it in there. You are a true man of The People, Jason. No censoring for you.

posted @ Tuesday, February 17, 2009 12:50 PM by Michael O'Neill

I love that peanut crack made it in there. You are a true man of The People, Jason. No censoring for you.

posted @ Tuesday, February 17, 2009 1:02 PM by Michael O'Neill

I have one client that is still on 2k only because they have so much embedded SQL in their custom apps and they don't want to take the time to analyze the embedded SQL for incompatibility.

posted @ Tuesday, February 17, 2009 1:13 PM by cherie aka dbmynx

You lost me at "tweeple".

posted @ Tuesday, February 17, 2009 1:19 PM by Adam Machanic

We are still running SQL 2000 because we do not have the staff/time to perform the migration to 2008. We have so many DTS packages that it would be a really long process. Management thinks our time is better spent on revenue generating projects rather than upgrading the infrastructure. In this economy, I can't say I disagree with them.

posted @ Tuesday, February 17, 2009 1:29 PM by moospot

Well I am still driving my Honda Accord 2000. It gets me from point A to point B perfectly well, my cost of ownership is very low, and I very much intend to drive it to the ground. Of course car salesmen hate this kind of attitude ;).

From the business point of view having to upgrade a perfectly well working system makes little sense. Imagine having to replace all the plumbing in your house every 3 to 5 years...

posted @ Wednesday, February 18, 2009 9:56 AM by Alex Kuznetsov

We have some @k and some 2K5 databases. Oddly enough, we are maintaining a mirror of our production 2K5 databases in 2k databases because we have been converting from Delphi and VB apps to VB.Net and C# . . . for over 2 years now! :-O

We have some DTS packages and some SSIS packages in Production but there has been no authorizedeffort to convert from DTS to SSIS . . . but, on the other hand, the DTS and SSIS packages weren't ever _actually_ autorized, either. ;-)

As for 2K8 . . . well, let's just say that we hope to get everything onto 2K5 before the open support for 2K5 sunsets. ;-) Then we'll worry about going to 2K8.

posted @ Wednesday, February 18, 2009 9:39 PM by Ralph Wilson

Name (required)

Email (required)

Website


Simple BBCode can be used like [url=http://example.com]Example[/url] and [B]

Home|Upcoming Events|Feeds | Privacy Statement | Terms Of Use
Copyright 2006 by Statistics IO, My SQL Server Blog