It can be difficult to find which Service Pack for SQL Server is installed on a machine. Neither is this information stated under SQL Server nor under Windows > Add Remove Programs. To get this information, use the following query:
SELECT SERVERPROPERTY ('productlevel')
You will get the following result (depending on the SP installed):
SP[1,2,3...]
I hope this helps. Stay tunned for more...
