Difference between revisions of "What version of SQL do I have?"
| Line 11: | Line 11: | ||
'''select SERVERPROPERTY ('edition')''' - Displays the current edition (Standard, Enterprise, etc.) | '''select SERVERPROPERTY ('edition')''' - Displays the current edition (Standard, Enterprise, etc.) | ||
| − | For information about SQL 2005 builds, see this [ | + | For information about SQL 2005 builds, see this [http://support.microsoft.com/kb/937137/en-us Microsoft article] . For SQL 2000, see [http://support.microsoft.com/kb/894905/en-us this] page. |
Revision as of 17:08, 19 October 2011
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.