Friday, February 24, 2012

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



You might also like:
SharePoint Usage Reports
Usage reports, collaboration and audit for SharePoint.
Document SharePoint Farm
Automatically generate SharePoint documentation.
*Sponsored


Check out these SharePoint products:

1 comment :

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

    ReplyDelete

Please Login and comment to get your questions answered!

You might also like:

Related Posts Plugin for WordPress, Blogger...