The SQL_ServerProperty spreadsheet allows a list of SQL instances to have their server property queried and the results listed directly within Excel.

The control buttons on the left hand side perform the following function:

Button	Functionality
Read	Performs the SQL SERVERPROPERTY query on the list of SQL instances in column D. The list will be processed sequentially starting at Cell D2 until an empty cell is found.
Clear Results	Clears the results from column E and higher

Populates a list of SQL Instances in column D.

To use the windows logon account to connect to the SQL server set cell “B15” to True, for SQL logon set to FALSE. If SQL security is used then a user ID and password must be specified in cells “B16” and “B17”

Select the read button to start the SERVERPROPERTY query, the results in column E and higher will be listed. The SERVERPROPERTY query will return the following results;

•  BuildClrVersion
• Collation
• CollationID
• ComparisonStyle
• ComputerNamePhysicalNetBIOS
• Edition
• EditionID
• EngineEdition
• FilestreamConfiguredLevel
• FilestreamEffectiveLevel
•  FilestreamShareName
• HadrManagerStatus
• InstanceName
• IsClustered
• IsFullTextInstalled
• IsHadrEnabled
•  IsIntegratedSecurityOnly
• IsLocalDB
• IsSingleUser
• LCID
• LicenseType
• MachineName
• NumLicenses
• ProcessID
• ProductLevel
• ProductVersion
•  ResourceLastUpdateDateTime
•  ResourceVersion
• ServerName
• SqlCharSet
• SqlCharSetName
• SqlSortOrder
• SqlSortOrderName

• Next >