IMPAX 6.5.1 Server Knowledge Base home > SQL Server home

Determining the version of SQL Server that is installed

Note:

Note:

Ensure that you are logged in using the AgfaService account; you cannot log into SQL Server Management Studio using the Administrator account.

This procedure applies to SQL Server 2005 and SQL Server 2008.

You can determine what server version, including service pack, you have installed. Provide this information to support when problems occur with the server.

To determine the version of SQL Server that is installed

  1. To open a new query window, in the SQL Server Management Studio, click New Query.

  2. Type:

    SELECT SERVERPROPERTY('productversion') Version, SERVERPROPERTY ('productlevel') Patch_Level, SERVERPROPERTY ('edition') Edition

  3. Click Execute. Execute


See also


Topic number: 47201

Applies to: IMPAX 6.5.1 Server Knowledge Base