how to check which sql-server Service pack is installed on system?

(In order to Enlarge images Please Right Click and Open images in New Tab).

Let us see solution

2

To check the SQL SERVER Information of Installed Version use this script:

   SELECT 
              SERVERPROPERTY('MachineName') as Host,
              SERVERPROPERTY('InstanceName') as Instance,
              SERVERPROPERTY('Edition') as Edition, /*shows 32 bit or 64 bit*/
              SERVERPROPERTY('ProductLevel') as ProductLevel, /* RTM or SP1 etc*/
              Case SERVERPROPERTY('IsClustered') when 1 then 'CLUSTERED' else
              'STANDALONE' end as ServerType,
              @@VERSION as VersionNumber

Product level will determine if you have SP1, SP2 Installed or not.

                                                  OR

SQL Server 2008 R2 – identify which service pack is installed on system

SELECT SERVERPROPERTY(‘ProductLevel’)

Result Set:

SP1

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s