If you are using SQL Server 2000 still today my very first recommendation to you is to upgrade to SQL Server 2012. SQL Server 2000 is now 12 years old product and since then many new enhancements as well features which are relevant to current growth and progress in Informational Industry. Now is the time to catch up with the latest trends. Here is one more point for you to notice if this helps you consider to upgrade to the latest version. One can’t upgrade directly from SQL Server 2000 to SQL Server 2012. You need to first upgrade to either SQL Server 2005/2008/R2 and then further plan to upgrade to SQL Server 2012. There is no direct upgrade path for SQL Server 2000 to SQL Server 2012. I strongly believe this is the time to upgrade to the latest version.
Well, also there is a rule that to let something continue if it is not broken and working fine. If you are following that rule and still using SQL Server 2000 I strongly suggest that you upgrade your SQL Server 2000 SP4 and update it with latest Security updates.
Here are two important SQL Server Security Updates.
Security Update for SQL Server 2000 Service Pack 4 (KB983811)
Security Update for SQL Server 2000 Service Pack 4 (KB983812)
As we are talking about SQL Server 2000 let me ask you a quick question – how many of you are still using SQL Server 2000 or earlier version in a production system on at least one server?
Reference: Pinal Dave (https://blog.sqlauthority.com)
6 Comments. Leave new
I hate to say Yes, we are still using SQL Server 2000 but those will be upgraded soon. :)
Yes…. :( We are also using SQL Server 2000.
We have a number of databases still on SQL 2000, although we now have a SQL 2012 cluster and the painful process of moving the databases is underway…
We’re still using SQL 2000 EE and have no plans to upgrade. Ever.
With an upgrade cost of more than $100,000 per machine (16 cores, under $1000 for the hardware), SQL 2012 is absurdly expensive. Microsoft has simply priced themselves out of (our) business.
We currently have 20 servers still running sql server 2000 ;(
And no plans to upgrade anytime soon….
My Organization still Uses Sql server 2000 on the production level and still seems no plan to upgrade it…….Sucks