:::: MENU ::::

Identify version and Edition of SQL Server

  • Oct 23 / 2008
  • 0
dbDigger

Identify version and Edition of SQL Server

Knowing your SQL Server environment is of primary importance. Almost all DBAs have documented and oral information for their SQL Server version and SQL Server edition. But if a DBA comes across a new environment some where then he should be able to know version , SP and edition information of SQL Server without asking any one.
Here is the script that will get version, edition and build information of SQL Server for you.

 
SELECT SERVERPROPERTY('productversion') as Build,  
 SERVERPROPERTY ('productlevel') as [Product Level],  
 SERVERPROPERTY ('edition') as Edition  
Consult us to explore the Databases. Contact us