How to tell what SQL Server version you are running

30 Aug 2011 ... Microsoft SQL Server 2008 (SP1) - 10.0.2573.0 (X64) ... 6.5, 7.0, 2000, 2005, 2008 and 2008 R2 based on the version number that is returned.

www.mssqltips.com