MyTechMantra.com
Connect With MyTechMantra.com

Like Us on Facebook    Follow Us on Twitter     Subscribe to our Feeds     Subscribe to NewsLetter


















Trending SQL Server Tips






SQL Server 2016: SERVERPROPERTY T-SQL Enhancement in SQL Server 2016

Read Comments   |   Related Topic: TSQL Enhancement in SQL Server 2016 > Next Topic: Database Backups in SQL Server


Click here to read about new T-SQL enhancements in SQL Server 2016 from the beginning...

SERVERPROPERTY Function T-SQL Enhancement in SQL Server 2016

SERVERPROPERTY is an inbuilt function which gives you information about the server instance.

Starting SQL Server 2016, this function is enhancement to include new properties such as InstanceDefaultDataPath, InstanceDefaultLogPath, ProductBuild, ProductBuildType, ProductMajorVersion, ProductMinorVersion, ProductUpdateLevel, and ProductUpdateReference.

SELECT
	SERVERPROPERTY('ProductVersion') 		AS ProductVersion,
	SERVERPROPERTY('ProductLevel') 		AS ProductLevel,
	SERVERPROPERTY('Edition') 			AS Edition,
	SERVERPROPERTY('EngineEdition') 		AS EngineEdition,
	SERVERPROPERTY('InstanceDefaultDataPath') 	AS InstanceDefaultDataPath,
	SERVERPROPERTY('InstanceDefaultLogPath') 	AS InstanceDefaultLogPath,
	SERVERPROPERTY('ProductBuild') 		AS ProductBuild,
	SERVERPROPERTY('ProductBuildType') 	AS ProductBuildType,
	SERVERPROPERTY('ProductMajorVersion') 	AS ProductMajorVersion,
	SERVERPROPERTY('ProductMinorVersion' 	AS ProductMinorVersion,
	SERVERPROPERTY('ProductUpdateLevel') 	AS ProductUpdateLevel,
	SERVERPROPERTY('ProductUpdateReference') 	AS ProductUpdateReference
GO

For More information, see, SERVERPROPERTY Function in SQL Server.

Related Tips

ALTER DATABASE SET AUTOGROW_SINGLE_FILE T-SQL Enhancement in SQL Server 2016
TRUNCATE TABLE WITH PARTITIONS T-SQL Enhancement in SQL Server 2016
COMPRESS and DECOMPRESS T-SQL Enhancement in SQL Server 2016
ALTER TABLE WITH (ONLINE = ON | OFF) T-SQL Enhancement in SQL Server 2016
MAXDOP for DBCC CHECKDB, DBCC CHECKTABLE and DBCC CHECKFILEGROUP

Thank you for taking your time to read this article. Let's be Connected....

Sign-up for Our Newsletter to Get Free SQL Server Tips and News to Build your Career

Like MyTechMantra on Facebook to get updates on What's Happening in SQL Server

Click the Next Page button to continue reading about Tutorial: Different Database Backup Options in SQL Server and click on the Previous Page button to revise the previouly read topic.

Previous Page.. Next Page..




Learn More...





Last Updated On: May 18, 2016



Share this Article



Receive Free SQL Server Tips and Keep Learning
Get Free SQL Server Tips




Please leave your Valuable Comment or Let us know how this article helped you: