Which Service Pack Is Installed On My SQL Server
From Wiki
To get the answer to this question run the code below
- SELECT SERVERPROPERTY('ProductVersion') AS SqlServerVersion,
- SERVERPROPERTY( 'ProductLevel') AS ServicePack
There are 3 possible values for ProductLevel
'RTM' = shipping version.
'SPn' = service pack version.
'Bn' = beta version.
Contributed by: --SQLDenis 17:29, 7 June 2008 (GMT)
Part of SQL Server Admin Hacks


