Number times Stored Proc. executed in week?

I have a server with SQL Server 2000 Enterprise Edition
with one production database.
Is there a way to determine the number of times a stored
procedure or view as executed within a week time interval?
Thanks,
Mike
You would have to log this yourself or with a tool. Three potentially
relevant articles:
http://www.aspfaq.com/search.asp?q=lumigent
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"Mike" <anonymous@.discussions.microsoft.com> wrote in message
news:f81401c43dfd$d38c1610$a001280a@.phx.gbl...
> I have a server with SQL Server 2000 Enterprise Edition
> with one production database.
> Is there a way to determine the number of times a stored
> procedure or view as executed within a week time interval?
> Thanks,
> Mike
|||Mike,
No, unless you have the trace files or any logic inside the proc which will
log into some table.
Dinesh
SQL Server MVP
--
SQL Server FAQ at
http://www.tkdinesh.com
"Mike" <anonymous@.discussions.microsoft.com> wrote in message
news:f81401c43dfd$d38c1610$a001280a@.phx.gbl...
> I have a server with SQL Server 2000 Enterprise Edition
> with one production database.
> Is there a way to determine the number of times a stored
> procedure or view as executed within a week time interval?
> Thanks,
> Mike