SQL Server 2016 – New SERVERPROPERTY properties

Hi Friends,

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;

SQL Server 2016


Prince Kumar Rastogi

Like us on FaceBook | Join the fastest growing SQL Server group on FaceBook

Follow Prince Rastogi on Twitter | Follow Prince Rastogi on FaceBook


About Prince Rastogi

Prince Rastogi is working as Database Administrator at Elephant Insurance, Richmond. He is having more than 8 years of experience and worked in ERP Domain, Wealth Management Domain. Currently he is working in Insurance domain. In the starting of his career he was working on SQL Server, Internet Information Server and Visual Source Safe. He is post graduate in Computer Science. Prince is ITIL certified professional. Prince likes to explore technical things for Database World and Writing Blogs. He is Technical Editor and Blogger at SQLServerGeeks.com. He is a regular speaker at DataPlatformDay events in Delhi NCR. He has also presented some in depth sessions about SQL Server in SQL Server Conferences in Bangalore.

View all posts by Prince Rastogi →

Leave a Reply

Your email address will not be published.