Always 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