What version of SQL do I have?

From Galen Healthcare Solutions - Allscripts TouchWorks EHR Wiki
Revision as of 12:54, 27 August 2008 by Jon hull (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 supports only certain builds of SQL Server 2000 and 2005 for its products. Please see the System Environment Specification (SES) document for the version of TW 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.

Retrieved from "https://wiki.galenhealthcare.com/index.php?title=What_version_of_SQL_do_I_have%3F&oldid=3580"