My first ever blog post was about the features of SQL Server 2000 that won’t work in SQL Server 2008, and as I have mentioned before, SQL Server 2000 will come out of Mainstream support today! What this means is that SQL Server 2000 will still be the subject of security fixes, and you can still get paid support for it, but other fixes will only be available if you take out extended support, which you have to pay for.
I know of several large organisations who will take out extended support and have planned for this. However if you weren’t aware of this then all I can suggest is that you look to migrate as soon as possible and in the meantime consider taking out extended support in the meantime if your database is mission critical.
The key resources for upgrade have been the subject of several of my recent posts but too summarise:
The subject say it all, as of today the mainstream support for SQL Server 2000 (SP4) and SQL Server 2005
Sad. SQL 2000 is a very good product. I find 2005 MGT studio to be clunky and very slow. And now they don't want to release an SP3 for all of the patches they have released on top of SP2. I have found SP2 to be very buggy.
Just curious! Where in the subject did it mention SQL Server 2005? -- My eyesight is not what it used to be!
Ron, I am puzzled; you're correct I didn't mention sql server 2005 in this post, but it isn't in my technorati tags or the categories either.
SQL Server 2005 SP1 is also out of mainstream support, if you see on my blog post you will get more information.