Tips and scripts relating to database administration. Mainly SQL Server but some MySQL and every now and again something different. Posts are brief and to the point.It's as much a place to make notes for my own use as anything else.
Thursday, 26 May 2011
SQL 2008 List all DMV Views
SELECT
name, type, type_desc FROM
sys.system_objects WHERE
name LIKE 'dm_%' ORDER BY
name
No comments:
Post a Comment