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

How to tell if SQL 2005 SP2 is installed?

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)