Blog Post

Get SQL Server Configuration using T-SQL

,

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.

https://github.com/rajendragp/RajendraScripts/blob/master/SQLServerConfiguration.sql

Original post (opens in new tab)

Rate

4.67 (3)

Share

Share

Rate

4.67 (3)