Finding Version of SQL Server

BronwenWeeGo.jpgAlways forget what number is what version of SQL Server so here’s list of the ones I commonly run into

SELECT SERVERPROPERTY(‘ProductLevel’)
GO

or
 
SELECT @@VERSION
GO

SQL 2005

Release 9.00.1399.06
SP1 9.00.2047
Hotfix918222 9.00.2153
SP2 9.00.3042

SQL 2000

release 8.00.194
sp1 8.00.384
sp2 8.00.534
sp3/3a 8.0.760
sp4 8.00.2039