Reasons to go SQL 2005 over SQL 2000

Hi all,

I am working with an outside consultant to upgrade our SQL 7 instance. He wants to upgrade to SQL 2000 and I want to go to SQL 2005. I want to have concrete reasons backed up with documentation as to why we should go SQL 2005 as opposed to SQL 2000.

For eg. support (why 2005 is better, ie. longer support), security(More secure, documentation), management, stability (number of patches released last year) etc.

I'd really appreciate it if someone could point me to an appropriate resource.

Thanks all,

SA.

Online Articles Regarding 2005 Enhancements over 2000

http://www.microsoft.com/sql/prodinfo/overview/whats-new-in-sqlserver2005.mspx|||Derek thank you for the informative post.

SA.|||

Hi,

This message was a useful one.

Can u throw some light on the cost as well.

regards
Shiv

|||One more thing to note is the product life cycle of Microsoft products. Check out http://www.microsoft.com/sql/support/lifecycle.mspx for more information. Initial cost outlay may be frightening for some but operations and maintenance cost have to be considered as part of your overall cost|||

Bass_player,

Thanks for the info on the lifecycle of Microsoft products.

By mentioning operation and maintenance costs did u mean that it would cost more to support SQL 2000 in the long run since the mainstream support ends much sooner than SQL 2005.

SA3446.