How to determine which Microsoft SQL Service Pack is running on a Microsoft SQL 2005 and a Microsoft SQL 2008 server.

Article:TECH76557  |  Created: 2009-01-07  |  Updated: 2014-01-06  |  Article URL http://www.symantec.com/docs/TECH76557
Article Type
Technical Solution

Product(s)

Issue



How to determine which Microsoft SQL Service Pack is running on a Microsoft SQL 2005 and a Microsoft SQL 2008 server.


Solution



When protecting Microsoft SQL resources, it is critical to know the service pack level of the SQL installation since it is used in disaster recovery or data  redirection scenarios. Symantec  Technical Services is providing this information to assist backup administrators in documenting their network  environments properly.

There are three ways to determine the service pack that is running on a Microsoft SQL 2005 server or a Microsoft SQL 2008 server:


1. From SQL Server Properties:

a. For Microsoft SQL 2005 server, Click Start | Programs | Microsoft SQL Server 2005 | SQL Server Management Studio Express (Figure 1)

Figure 1

 


b. For Microsoft SQL 2008 server, Click Start | Programs | Microsoft SQL Server 2008 | SQL Server Management Studio  (Figure 2)

Figure 2

 

c. Right-click the Microsoft SQL server name and select Properties

d. Check the product version of the SQL server (Figure 3)

Figure 3

 

2. Using the SQL Query Analyzer:

a. Open the Microsoft SQL Server Management Studio

b. Click "New Query" across the top.

After launching Query Analyzer, type in the following query:

Select @@ Version

Press the F5 key (Figure 4).


Figure 4

 


The query will be executed, and the information pertaining to the service pack currently installed is displayed in the bottom half of the screen.

The product version for each service pack level will show as follows:
Version 9.00.5000.00 SQL Server 2005 with service pack 4.
Version 9.00.4035 SQL Server 2005 with service pack 3.
Version 9.00.3054 SQL Server 2005 with service pack 2 GDR2.
Version 9.00.3050 SQL Server 2005 with service pack 2 GDR1.
Version 9.00.3042 SQL Server 2005 with service pack 2.
Version 2005.90.2047 SQL Server 2005 with service pack 1.
Version 2005.90.1399 SQL Server 2005 with no service pack applied


Version 10.00.4000.00 SQL Server 2008 with Service Pack 2
Version 10.00.2723.00 SQL Server 2008 with Cumulative Update 3 (includes SP 1 and hot-fixes)
Version 10.00.2531.00 SQL Server 2008 with service pack 1.
Version 10.00.1600.00 SQL Server 2008, with no service pack applied.


3)Using the SQL Query Analyser:

a. Open the Microsoft SQL Server Management Studio

b. Click "New Query" across the top.

c. After launching Query Analyzer, type in the following query:

SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')

Press the F5 key (Figure 5).

Figure 5

 

The query will be executed, and the the following results are returned:

The product version (for example, 10.0.1600.22)
The product level (for example, RTM)
The edition (for example, Enterprise)










 



Legacy ID



336942


Article URL http://www.symantec.com/docs/TECH76557


Terms of use for this information are found in Legal Notices