List DMVs

what is the query to list all DMVs in SQL 2005 ?
I tried select * from sysobjects where name like 'dm%'
and it returned them
However select * from sys.objects where name like 'dm%' returns no results
Both executed in master database
Anyways, what is the right SQL to obtain list of DMVs as sysobjects is a
deprecated system table
Hi Hassan
Try this:
SELECT * FROM sys.system_objects
WHERE name LIKE 'dm%'
HTH
Kalen Delaney, SQL Server MVP
http://sqlblog.com
"Hassan" <Hassan@.hotmail.com> wrote in message
news:OpvHSd0FHHA.924@.TK2MSFTNGP02.phx.gbl...
> what is the query to list all DMVs in SQL 2005 ?
> I tried select * from sysobjects where name like 'dm%'
> and it returned them
> However select * from sys.objects where name like 'dm%' returns no results
> Both executed in master database
> Anyways, what is the right SQL to obtain list of DMVs as sysobjects is a
> deprecated system table
>

List DMVs

what is the query to list all DMVs in SQL 2005 ?
I tried select * from sysobjects where name like 'dm%'
and it returned them
However select * from sys.objects where name like 'dm%' returns no results
Both executed in master database
Anyways, what is the right SQL to obtain list of DMVs as sysobjects is a
deprecated system tableHi Hassan
Try this:
SELECT * FROM sys.system_objects
WHERE name LIKE 'dm%'
HTH
Kalen Delaney, SQL Server MVP
http://sqlblog.com
"Hassan" <Hassan@.hotmail.com> wrote in message
news:OpvHSd0FHHA.924@.TK2MSFTNGP02.phx.gbl...
> what is the query to list all DMVs in SQL 2005 ?
> I tried select * from sysobjects where name like 'dm%'
> and it returned them
> However select * from sys.objects where name like 'dm%' returns no results
> Both executed in master database
> Anyways, what is the right SQL to obtain list of DMVs as sysobjects is a
> deprecated system table
>

List DMVs

what is the query to list all DMVs in SQL 2005 ?
I tried select * from sysobjects where name like 'dm%'
and it returned them
However select * from sys.objects where name like 'dm%' returns no results
Both executed in master database
Anyways, what is the right SQL to obtain list of DMVs as sysobjects is a
deprecated system tableHi Hassan
Try this:
SELECT * FROM sys.system_objects
WHERE name LIKE 'dm%'
--
HTH
Kalen Delaney, SQL Server MVP
http://sqlblog.com
"Hassan" <Hassan@.hotmail.com> wrote in message
news:OpvHSd0FHHA.924@.TK2MSFTNGP02.phx.gbl...
> what is the query to list all DMVs in SQL 2005 ?
> I tried select * from sysobjects where name like 'dm%'
> and it returned them
> However select * from sys.objects where name like 'dm%' returns no results
> Both executed in master database
> Anyways, what is the right SQL to obtain list of DMVs as sysobjects is a
> deprecated system table
>