What version of SQL do I have?

From Galen Healthcare Solutions - Allscripts TouchWorks EHR Wiki
Revision as of 17:11, 19 October 2011 by Joe.Nyiri (talk | contribs)
Jump to navigation Jump to search

It is very important to know which version of SQL Server you are running and which build it is. AllScripts only supports certain builds of SQL Server 2000 and 2005 for its products. In newer releases, only SQL Server 2005 and 2008 are supported. Please see the System Environment Specification (SES) document for the version of Enterprise that you are running to determine the required version and build.

The following queries will allow you to determine which version and build you currently have. These need to be run from the query analyzer on the Master database.

  • select @@version
    - Displays the Version (ie SQL 2000), build number, processor class (X86, X64), and installation date.
  • select SERVERPROPERTY ('productlevel')
    - Displays the Service Pack level.
  • select SERVERPROPERTY ('productversion')
    - Displays the current build.
  • select SERVERPROPERTY ('edition')
    - Displays the current edition (Standard, Enterprise, etc.).

For information about SQL 2005 builds, see this Microsoft article . For SQL 2000, see this page.