T-SQL script to Identify the SQL Server version and edition
Execute below T-SQL Script to get the SQL Server version details.
1 | SELECT SERVERPROPERTY ( 'productversion' ) as ProductVersion, |
2 | SERVERPROPERTY ( 'productlevel' ) as Productlevel, |
3 | SERVERPROPERTY ( 'edition' ) as Edition |
-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