Other Metadata Queries

Get Referenced Object Hierarchy - Retrieves all objects and their relationship hierarchies. One query returns detail items, the other has the referenced objects pivoted into a comma separated list

Get Database Extended Properties - Retrieves extended properties info for a database.

Get Queues and Rules Metadata - Returns lists of Database Queues and legacy Rules

Get Database and Server Cross-References - Returns a list of cross-database (chaining) references and cross-server references (linked servers)

Get Column Output List for Query - Get an output column list for any valid query. Contains base query plus one wrapped in a function with bells and whistles

Get SQL Server and Agent Uptime - Get SQL Server Uptime details (SQL Server and SQL Agent)

Get SQL Server Version Information - Parses SQL Server version/edition into a single row result

Get Power Management Settings