database_design

APPNOTE: How to determine the version of SQL Server

The PMT is specified to operate on SQL Server 2005 Service Pack 3, or better. This Application Note shows how to determine the version of SQL Server being run and its service pack level.

Instructions – from within PMT

  • Open the Administration area of the PMT.
  • Select the Database tab. You will see the following:


    The version of the SQL Server hosting the PMT database is shown.

Instructions – from within SQL Server

  • Open SQL Server 2005 Enterprise Manager
  • Create a new query on the PMT database.
  • Run the following query:

    SELECT SERVERPROPERTY(‘productversion’), SERVERPROPERTY (‘productlevel’), SERVERPROPERTY (‘edition’)

  • You should see this:


In both cases, use the following table to identify the service pack of the server:


Reference:

The following link provides greater detail on this topic.

<http://support.microsoft.com/kb/321185>