In this article, we will explain
- How to get the SQL Server Instance Information using “SERVERPROPERTY”?
- How to get the SQL Server Instance Information remotely?
What’s the SERVERPROPERTY?
SERVERPROPERTY is a System Defined function used to return the SQL Server Instance Information.
SERVERPROPERTY Syntax
SERVERPROPERTY ('propertyname')
“propertyname“ is one of the following values.
- MachineName.
- ComputerNamePhysicalNetBIOS.
- ServerName.
- InstanceName.
- InstanceDefaultDataPath.
- InstanceDefaultLogPath.
- Edition.
- EditionID.
- EngineEdition.
- ProductBuild.
- ProductBuildType.
- ProductLevel.
- ProductMajorVersion.
- ProductMinorVersion.
- ProductUpdateLevel.
- ProductVersion.
- BuildClrVersion.
- Collation.
- LCID.
- IsSingleUser.
- IsIntegratedSecurityOnly.
- IsHadrEnabled.
- HadrManagerStatus.
- IsAdvancedAnalyticsInstalled.
- IsClustered.
- IsFullTextInstalled.
- ProcessID.
Continue reading SQL Server: Get the Detailed Information Via SERVERPROPERTY