Database Reference
In-Depth Information
Summary
In this chapter, we discussed the importance of metadata. We explored some of the
metadata that exists within SQL Server and provided two examples of useful T-SQL
metadata queries. We identified a very flexible and reusable pattern for collecting data-
base metadata in an enterprise environment. Lastly, we created an Integration Services
package that retrieves a list of SQL Server instances to monitor and then logs the res-
ults to a centralized repository.
Search WWH ::




Custom Search