SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Do You Support the Ancient Ones?

Do You Support the Ancient Ones?

Are you still supporting SQL Server 2000? How about 7.0 or 6.5?

Officially, Microsoft support has ended for these products. I know plenty of companies that are still using SQL Server 2000. Even within Microsoft SQL 2000 is still in use. Mostly it's old internal applications that no longer have development budgets and have entered the "sustained engineering" phase. In other words, no one is willing to pay for the labor to upgrade it, and no one is willing to pull the plug. Or maybe there's just one person still using it, but that one person has enough stroke to keep the application on life support.

I read a good article called Ordering Tables To Preserve Referential Integrity posted on SQL Server Central recently that included a script for calculating a logical order for tables based on defined referential keys. Someone requested a version of the script that would work on SQL Server 2000, and the author, R Glen Cooper, gladly posted an update for SQL 2000.

That got me thinking that I think it is time to stop officially supporting SQL Server 2000. I have frequently in the past posted versions of scripts that are compliant with SQL Server 2000 T-SQL. More recently, most of my writings have been on features that do not exist in SQL Server 2000 (such as database mirroring), and thusly SQL 2000 never entered the picture. Going forward, I will no longer be posting scripts specifically written to work in SQL Server 2000. I will gladly help out if someone needs a script for SQL 2000, but it will be by request only.

Chime In

I'd love to hear if other people are still supporting SQL Server 2000 and to what degree. Please post any feelings you may have on the subject.


Posted by Glen Cooper on 29 March 2009

I still support 2000, but downward compatibility doesn't seem to mean much anymore.

In the old days it used to be a selling point.

Posted by David.Poole on 30 March 2009

There are some huge legacy apps out there and in my place of work a huge number of DTS packages.  We even have some of the DTS replication objects and these are not easy to replace.

Hopefully we will be going to SQL2008 ASAP.

Posted by Robert Davis on 30 March 2009

Good luck with that David!!!

Glen, I agree about downward compatibility, and I think user's would love to see SQL Server take the Office approach to backwards compatibility and make it possible to backup a database to a lower compatibility level so that it can be restored on an earlier version (SQL 2005 to SQL 2000, e.g.).

For me personally, I'm finding that the SQL 2000 specific questions are getting rarer, and I find myself remembering less and less about it.

Posted by Uttam Parui on 3 May 2009

SQL Server 2000 is officially supported by Microsoft until 09/04/2013. For more information, see support.microsoft.com/lifecycle

Only hotfix support has stopped for SQL Server 2000 since mainstream support stopped in 2008. As long as customers have the latest supported service pack for SQL Server 2000, they will still be supported until 09/04/2013.

On the same lines, SQL Server 7.0 will be supported until 11/01/2011 as long as you have the latest service pack. See support.microsoft.com/lifecycle for details.

By providing this data I am not saying that you should stay on SQL 7.0 or SQL 2000 but wanted to make sure that the supportability statement is properly understood by all.

Leave a Comment

Please register or log in to leave a comment.