Troubleshooting Microsoft SQL Server

Blog is a collection of misc troubleshooting tips collected while supporting Microsoft SQL Server 2000, 2005, and 2008. Specialty area covered is SQL Server Data Replication including Transactional Replication, Merge Replication, Change Data Capture, and

Browse by Tags

Tagged Content List
  • Blog Post: Query to return list of Dynamic Management Views

    I don't always remember names of the SQL Server Dynamic Managment views. Books Online is great, but here is a simple query to get a list of DMVs SELECT * FROM sys . all_objects WHERE [name] LIKE '%dm_%' AND [type] IN ( 'V' , 'TF' , 'IF' ) AND [schema_id] = 4 ORDER BY [name]
Page 1 of 1 (1 items)