Thursday, June 4, 2015

Find service pack level on SQL server

I am not a DBA, but I have on occasion had to find out if SQL is at a certain service pack level.  Since you cannot find this through help about in SQL Management Studio you can run the following query.

SELECT SERVERPROPERTY('productlevel')