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