How to check which version of SQL and service pack your Enterprise Console database is installed in

  • Article ID: 113034
  • Rating:
  • 1 customers rated this article 6.0 out of 6
  • Updated: 21 Jun 2011

When you are looking to upgrade your Enterprise Console database, you often need to know which version of SQL you are using. The following instructions use OSQL commands to find SQL version and edition information. It is a summary of the information given in this Microsoft knowledgebase article

  1. In order to use this procedure, you will need to know which SQL instance you are using and where it is located (the default is .\SOPHOS). This information is found in the database connection string, which is explained in How to check which SQL instance your Enterprise Console database is installed in. Once you have this information, you are ready to proceed with the following steps.
  2. On a server with SQL, MSDE or SQL client installed (this may be the server on which the database is installed), log on as a user with administrative rights over the SQL instance.
  3. Open a command prompt (Start | Run | type cmd and click OK) and type the following commands, followed by the Enter key at the end of each line (replace .\SOPHOS with the server\instance name string obtained in step 1):

    osql -E -S .\SOPHOS -h-1 -Q "SET NOCOUNT ON; SELECT 'Version=', CONVERT(NVARCHAR,SERVERPROPERTY('productversion'))" >.\sqlout.txt
    osql -E -S .\SOPHOS -h-1 -Q "SET NOCOUNT ON; SELECT 'ProductLevel=', CONVERT(NVARCHAR,SERVERPROPERTY ('productlevel'))" >>.\sqlout.txt
    osql -E -S .\SOPHOS -h-1 -Q "SET NOCOUNT ON; SELECT 'Edition=', CONVERT(NVARCHAR,SERVERPROPERTY ('edition'))" >>.\sqlout.txt

    These commands will create a text file named sqlout.txt in the current working directory of the command prompt.

    Note: The ".\SOPHOS" in the above example references the local SOPHOS named instance of SQL.  In some circumstances you will need to change this to [MachineName]\SOPHOS as the "." notation will not always work.  Typically this is the case when accessing a local MSDE instance of SQL.

  4. Open the file slqout.txt.

    The contents of the file will be something like this:
    Version= 8.00.2039
    ProductLevel= SP4
    Edition= Desktop Engine

If you need more information or guidance, then please contact technical support.

Rate this article

Very poor Excellent