Query to find version information for SQL
From EnterpriseVaultFaq.com - Wiki
Description
| SQL Script Description | |
|---|---|
| Script Purpose: | Gets SQL Server Version |
| Description: | Gets SQL Server Version |
| Script Input: | - |
| Script Output: | Product Version, Product Level, SQL Edition |
| Tested on EV Versions: | - |
Source
SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')