If you are working on sql server you know how to create a simple query which will help to find the sql server version and service pack level.

SELECT SERVERPROPERTY (‘EDITION’) AS SQL_Server_Edition
SELECT SERVERPROPERTY (‘PRODUCTLEVEL’) AS SQL_Product_Level
SELECT SERVERPROPERTY (‘PRODUCTVERSION’) AS SQL_Version

 

I run the query once again after upgrading to SP2,

You can check from the properties but have to search with version, the following snapshot show the version of RTM. If you upgrade to SP2 that will be 10.50.4000.0