KBA45007: How to check SQL Server version

Knowledge Base Article:	45007
Applicable Versions:	N-compass 3.0 and later, Report Manager | N-compass 3.2
Date Created/Updated:	November 6, 2012

Introduction

The following instructions allow you to identify the version of SQL server that you are currently running.

Resolution

Check your Microsoft SQL Server Version:

1. Click Start>All Programs>Microsoft SQL Server 2005 (or 2008)>SQL Server Management Studio.

   The SQL Server Management Studio window appears.

2. Connect to the SQL server that will be used with N-compass and right-click it.

   The SQL Server Properties dialog box appears.

3. Select New Query.

   A new query window will appear in the right-hand pane of the dialog box.

4. Enter the following query:

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

5. Click Execute.

   The version, service pack and edition of SQL Server displays.

   For example:

   2008
   Microsoft SQL Server 2008 Standard Edition with SP1 OR Microsoft SQL Server 2008 Enterprise Edition with SP1.
   Product version:10.00.xxxx.xx SQL version: 2008

For information on server requirements, refer to System requirements.