How to tell how many times an SQL executed in v7 or v2000?

Using the dm_exec_query_stats in 2005, I know I can get the number of
executions for a particular sql_handle, but is it possible to get the
number of execs for a SQL in version 7 or 2000? Also is it possible to
get reads/writes/etc in these early versions?
Thanks.Rick (rick_snow_ora@.hotpop.com) writes:
> Using the dm_exec_query_stats in 2005, I know I can get the number of
> executions for a particular sql_handle, but is it possible to get the
> number of execs for a SQL in version 7 or 2000? Also is it possible to
> get reads/writes/etc in these early versions?
These new Dynamic Management Views in SQL 2005 are just stunning. There
is some much information, that it just leaves you breahless. And a lot of
that is not available in SQL 2000. master.dbo.syscacheobjects is proabbly
what comes closest in this case, but it does not have all that information.
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx