SQL SERVER – List All the DMV and DMF on Server

Posted by pinaldave on SQL Authority See other posts from SQL Authority or by pinaldave
Published on Sat, 15 May 2010 01:30:52 +0000 Indexed on 2010/05/15 1:45 UTC
Read the original article Hit count: 796

“How many DMVs and DVFs are there in SQL Server 2008?” – this question was asked to me in one of the recent SQL Server Trainings.

Answer is very simple:

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

Reference: Pinal Dave (http://blog.sqlauthority.com)


Filed under: Pinal Dave, SQL, SQL Authority, SQL Query, SQL Scripts, SQL Server, SQL Tips and Tricks, T SQL, Technology Tagged: SQL DMV

© SQL Authority or respective owner

Related posts about Pinal Dave

Related posts about sql