Breadcrumbs

Finding the version and edition of SQL being used for an instance

This support note applies to:

  • AO Document Manager (AU)

  • AO Classic Document Manager (AU)

  • AO Classic Document Manager (NZ)

  • AO Document Manager (NZ)

  • AE Statutory Reporter (NZ)

  • Workpapers (NZ)

  • AO Practice Manager (NZ)

  • AO Practice Manager (AU)

  • AO Workpapers (AU)

  • AO Statutory Reporter (AU)

  • AO Tax (AU)

  • AE Workpapers (AU)

  • AE Statutory Reporter (AU)

  • AE Document Manager (NZ)

  • AE Practice Manager (NZ)

  • AE Practice Manager (AU)

  • AE Document Manager (AU)

  • AE Tax (NZ)

  • AO Corporate Compliance (AU)

  • AE Tax Series 6 & 8 (AU)

  • AE Tax (AU)

  • AE Corporate Compliance (AU)

Article ID: 35180

If you need to find the version and edition of SQL for any reason, you can do so with a simple query.

To identify the version and edition of SQL

  1. Follow the menu path: START > All programs > Microsoft SQL Server 20xx > SQL Server Management Studio. The Connect to Server window appears.

  2. Enter the correct server and instance name as required and login details then click Connect. The instance appears.

  3. Click New Query. A query window appears.

  4. Type select @@version and click Execute. Query executed successfully appears.

  5. Expand the column under the results tab. The version/edition information becomes visible.