Saturday, May 15, 2010

List All the DMV and DMF on Server in SQL Server

Its a very simple query


SELECT name, type, type_desc
FROM sys.system_objects
WHERE name LIKE 'dm_%'
ORDER BY name

No comments:

Post a Comment