I hope that most of us uses SERVERPROPERTY in SQL Server to collect various information about the Instance. I used SERVERPROPERTY most of the time when I got a new server added to my responsibility list. This is also very useful to collect the Instance information before and after the patching activity. Microsoft has been provided SQL Server 2016 community technology preview (CTP) with multiple new and improved features. In this row, eight new properties have been added to SERVERPROPERTY syntax. Which makes it much more powerful. Some of these are also available with the latest update of SQL Server 2012 and SQL Server 2014. Let me show you these new properties on SQL Server 2016 CTP 3.3.
Select SERVERPROPERTY('InstanceDefaultDataPath') as DefaultDataPath; Select SERVERPROPERTY('InstanceDefaultLogPath') as DefaultLogPath; Select SERVERPROPERTY('ProductBuild') as ProductBuild; Select SERVERPROPERTY('ProductBuildType') as BuildType; Select SERVERPROPERTY('ProductMajorVersion') as MajorVersion; Select SERVERPROPERTY('ProductMinorVersion') as MinorVersion; Select SERVERPROPERTY('ProductUpdateLevel') as UpdateLevel_CU; Select SERVERPROPERTY('ProductUpdateReference') as UpdateRefernce_KBArticle;
Prince Kumar Rastogi