SQL Server 2008 System Functions to Monitor the Instance, Database, Files, etc.
Posted
on SQL Server Central
See other posts from SQL Server Central
Published on 2010/05/05
Indexed on
2010/05/05
6:09 UTC
Read the original article
Hit count: 133
Filed under:
SQL Server provides several system meta data functions which allow users to obtain property values of different SQL Server objects and securables. Although you can also use the SQL Server catalog views or Dynamic Management Views to obtain much of this information, in some circumstances the system meta data functions simplify the process. In this tip I am going to demonstrate some of the available system meta data functions and their usage in different scenarios.
© SQL Server Central or respective owner