sql server instance version

I have been given a list of all corporate owned MS SQL Server instances for risk assessment purposes, I was hoping it would detail version, i.e 2000, 2005, 2008, 2012 etc. However by instance version it statues v9, 10, 105 etc. Is there anyway to link those to the actual version of the product?
Who is Participating?

Improve company productivity with a Business Account.Sign Up

Lee SavidgeConnect With a Mentor Commented:
Here is the bible of SQL versions:

pma111Author Commented:
Thanks, are any of the older version of SQL out of support now? What do they still patch? What versions have been cut off from support/patches?
Improve Your Query Performance Tuning

In this FREE six-day email course, you'll learn from Janis Griffin, Database Performance Evangelist. She'll teach 12 steps that you can use to optimize your queries as much as possible and see measurable results in your work. Get started today!

Lee SavidgeCommented:
Sorry for posting just links, but there's no point in my rewriting it when it's been written before :)
pma111Author Commented:
Thanks, What does extended support actually mean above and beyond mainstream support? How do you get mainstream support, and why would you pay for it? What exactly does it give you?
Lee SavidgeCommented:
I don't know. That would be a different question to post. I am not familiar with Microsofts support.
PaulConnect With a Mentor Commented:
Too late to offer the useful URL's already supplied - but I'm pleased you are doing such a risk assessment.

One tip I would offer is that, in addition to the sql sever version issues already mentioned, is you should also be looking at the hardware (e.g. age, vendor, warranty) and the operating systems each sql server is depending on. Combinations of these factors may influence levels of risk and help focus on upgrade/replacement recommendations.

Good luck with this
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.