Find current Service Pack installed

Posted on

SQL Versions: 2005, 2008, 2008 R2, 2012, 2014

If you need to see the specific version of SQL Service Pack installed. This SP is not the same as the Windows OS SP.

SELECT SERVERPROPERTY(‘ProductLevel‘)

Advertisements