As a SQL architect or Database administrator, it is required to know how to get SQL Server configuration using T-SQL. This post will share how to accomplish this task.
The following T-SQL script returns the following information for your SQL Server instance.
Domain
SQLServerName
InstanceName
ComputerNamePhysicalNetBIOS
Clustered or not clustered
ClusterNodes
Active Node
HostIPAddress
PortNumber
Authentication Mode
Product Version
ProductLevel
Resource Version
ResourceLastUpdateDateTime
EngineEdition
BuildClrVersion
Collation
ComparisonStyle
FullTextInstalled or not
SQLCharset
SQLCharsetName
SQLSortOrderName
Platform
Windows Version
ProcessorCount
ProcessorType
Physical Memory
PageFile
SQL Server Installation Location
BinariesPath
Error Logs Location
Service account for SQL Server service
Service account for SQL Server agent
Startup type for SQL Server service
Startup type for SQL Server agent server
Instance Last Start Date
Take the script from the link and execute it on your SQL instance.