Monday 18 February 2013

T-SQL script to Identify the SQL Server version and edition


Execute below T-SQL Script to get the SQL Server version details.
1SELECT SERVERPROPERTY ('productversion') as ProductVersion,
2SERVERPROPERTY ('productlevel') as Productlevel,
3SERVERPROPERTY ('edition') as Edition
Output:
-Product version (for example, 10.0.1600.22)
-Product level (for example, SP3)
-Edition (for example, Development)
SQL Server 2012 version number examples
11.0.2316 SQL Server 2012 CU1
11.0.2100.6 SQL Server 2012 RTM

No comments:

Post a Comment