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
|
|
|
|