出典:Wikipedia
出典:『Wikipedia』 (2010/08/09 10:39 UTC 版)
In database programming, the scome technique is a mechanism used to collect RDBMS system data from remote linked servers via a central SQL Server. This data can be used to monitor the status of managed database servers and their associated databases. The method comprises two T-SQL stored procedures that together are used to iterate over records in SQL Server system tables and Dynamic Management Views. The stored procedures are typically executed from a central master SQL Server.