How to see if SQL Server 2005 SP2 is installed?

Thanks admin, your blog posts are always so informative, which I have gained alot of knowledge from, thanks again.

How will I check if SQL Server 2005 SP2 is installed?

How to tell if SQL 2005 SP2 is installed?

Method 1:

To see if SQL 2005 Service Pack 2 is installed execute the following command:

Select @@version

This query should come up with something like this:

Microsoft SQL Server 2005 - 9.00.3042.00 (Intel
X86)   Feb  9 2007 22:47:07   Copyright (c) 1988-2005 Microsoft
Corporation  Standard Edition on Windows NT 5.2 (Build 3790: Service
Pack 2)

2005 - 9.00.3042.00  means it has SP2 installed

Here is a list of values for other version and service packs

Method 2:

Here is another visual way to see if SQL Service Pack 2 is installed:

Open SQL Server Configuration Manager --> Right click on the SQL Server Service that is running --> Click on the Advanced Tab and look for the Service Pack Level property, it should say 2

Pretty Simple and Visual