Cool Tips‎ > ‎

Other Metadata Queries

 

Title

Description

Applicability

 

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


2000, 2005, 2008, 2008R2, 2012

2014, 2016, 2017

 

Get Database Extended Properties

Retrieves extended properties info for a database.

2000, 2005, 2008, 2008R2, 2012

2014, 2016, 2017

 

Get Queues and Rules Metadata

Returns lists of Database Queues and legacy Rules

2000, 2005, 2008, 2008R2, 2012

2014, 2016, 2017

 

Get Database and Server Cross-References

Returns a list of cross-database (chaining) references and cross-server references (linked servers)

2000, 2005, 2008, 2008R2, 2012

2014, 2016, 2017

 


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


2000, 2005, 2008, 2008R2, 2012

2014, 2016, 2017

 

Get SQL Server and Agent Uptime

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

2000, 2005, 2008, 2008R2, 2012

2014, 2016, 2017

 

Get SQL Server Version Information

Parses SQL Server version/edition into a single row result

2000, 2005, 2008, 2008R2, 2012

2014, 2016, 2017

 

Get Power Management Settings

Get power management settings

2000, 2005, 2008, 2008R2, 2012

2014, 2016, 2017

 




Comments