How to check what service pack is installed

Use the following code in SSMS Query Editor to get version, edition and Service Pack information:


USE master;

SELECT @@Version
/*
Microsoft SQL Server 2008 (SP1) - 10.0.2531.0 (X64)   Mar 29 2009 10:27:29  
Copyright (c) 1988-2008 Microsoft Corporation 
Enterprise Edition (64-bit) on Windows NT 6.1 <X64> (Build 7600: )
*/
SELECT SERVERPROPERTY('ProductLevel')
-- SP1