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