sql List all DMV and DMF

SELECT name, type, type_desc
FROM sys.system_objects
WHERE name LIKE 'dm[_]%'
ORDER BY name
Thanks to SQL Authority.

Updated: Wednesday 8th June 2011, 07:10pm

There are 0 comments

Leave a comment of your own

Comments are currently closed.