What is my SQL Server Version, Service Pack, Edition

Requirement: Wanted to check the installed SQL Server version service pack level.
SELECT @@version ? It didn’t give me the Service pack information.

Query to Check SQL Server version, Service pack and Edition:

SELECT SERVERPROPERTY('productversion') [Product Version], 
          SERVERPROPERTY ('productlevel') [Service Pack],
                    SERVERPROPERTY ('edition') [Edition]
sql server version and service pack check

KB Article: http://support.microsoft.com/kb/321185

Salaudeen Rajack

Salaudeen Rajack is a SharePoint Architect with Two decades of SharePoint Experience. He loves sharing his knowledge and experiences with the SharePoint community, through his real-world articles!

One thought on “What is my SQL Server Version, Service Pack, Edition

  • July 5, 2013 at 2:05 PM

    Can we use Powershell?
    Local vs Remote SQL Properties!!

    Reply

Leave a Reply