Marc Valk dot Net
blogging about…… Microsoft, Cloud Computing
Identify SQL Server version
30 Oct 2009Some TSQL command to identify the version of SQL you are running:
SQL Server 6.5
SELECT @@VERSION
|
Version Number
|
Service Pack
|
|
6.50.479
|
SQL Server 6.5 Service Pack 5a (SP5a) Update
|
|
6.50.416
|
SQL Server 6.5 Service Pack 5a (SP5a)
|
|
6.50.415
|
SQL Server 6.5 Service Pack 5 (SP5)
|
|
6.50.281
|
SQL Server 6.5 Service Pack 4 (SP4)
|
|
6.50.258
|
SQL Server 6.5 Service Pack 3 (SP3)
|
|
6.50.240
|
SQL Server 6.5 Service Pack 2 (SP2)
|
|
6.50.213
|
SQL Server 6.5 Service Pack 1 (SP1)
|
|
6.50.201
|
SQL Server 6.5 RTM
|
SQL Server 7.0
SELECT @@VERSION
|
Version Number
|
Service Pack
|
|
7.00.1063
|
SQL Server 7.0 Service Pack 4 (SP4)
|
|
7.00.961
|
SQL Server 7.0 Service Pack 3 (SP3)
|
|
7.00.842
|
SQL Server 7.0 Service Pack 2 (SP2)
|
|
7.00.699
|
SQL Server 7.0 Service Pack 1 (SP1)
|
|
7.00.623
|
SQL Server 7.0 RTM (Release To Manufacturing)
|
SQL 2000
SELECT SERVERPROPERTY(‘productversion’), SERVERPROPERTY (‘productlevel’), SERVERPROPERTY (‘edition’)
|
Release
|
Sqlservr.exe
|
|
RTM
|
2000.80.194.0
|
|
SQL Server 2000 SP1
|
2000.80.384.0
|
|
SQL Server 2000 SP2
|
2000.80.534.0
|
|
SQL Server 2000 SP3
|
2000.80.760.0
|
|
SQL Server 2000 SP3a
|
2000.80.760.0
|
|
SQL Server 2000 SP4
|
2000.8.00.2039
|
SQL 2005
SELECT SERVERPROPERTY(‘productversion’), SERVERPROPERTY (‘productlevel’), SERVERPROPERTY (‘edition’)
|
Release
|
Sqlservr.exe
|
|
RTM
|
2005.90.1399
|
|
SQL Server 2005 Service Pack 1
|
2005.90.2047
|
|
SQL Server 2005 Service Pack 2
|
2005.90.3042
|
|
SQL Server 2005 Service Pack 3
|
2005.90.4035
|
SQL 2008
SELECT SERVERPROPERTY(‘productversion’), SERVERPROPERTY (‘productlevel’), SERVERPROPERTY (‘edition’)
|
Release
|
Sqlservr.exe
|
|
RTM
|
2007.100.1600.0
|
|
SQL Server 2008 Service Pack 1
|
2007.100.2531.0
|
- Tags: SQL Server