Determining what stored procedures are used

Hi,
We have a large database with over 1000 stored procedures,
we need to determine when last these procedures where used
so we can remove and redundant/unused procedures. Is
there any way to do this using SQL Server 2000?
Thanks,
StephenStephen, the answer is simple: yoes, you should use the Profiler. Check this
tool in Books OnLine, it is very powerful!
--
Dejan Sarka, SQL Server MVP
FAQ from Neil & others at: http://www.sqlserverfaq.com
Please reply only to the newsgroups.
PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org
"Stephen Young" <stephen_c_young@.hotmail.com> wrote in message
news:1af101c3737d$540f7030$a301280a@.phx.gbl...
> Hi,
> We have a large database with over 1000 stored procedures,
> we need to determine when last these procedures where used
> so we can remove and redundant/unused procedures. Is
> there any way to do this using SQL Server 2000?
> Thanks,
> Stephen|||Thanks, will give it a shot.
>--Original Message--
>Stephen, the answer is simple: yoes, you should use the
Profiler. Check this
>tool in Books OnLine, it is very powerful!
>--
>Dejan Sarka, SQL Server MVP
>FAQ from Neil & others at: http://www.sqlserverfaq.com
>Please reply only to the newsgroups.
>PASS - the definitive, global community
>for SQL Server professionals - http://www.sqlpass.org
>"Stephen Young" <stephen_c_young@.hotmail.com> wrote in
message
>news:1af101c3737d$540f7030$a301280a@.phx.gbl...
>> Hi,
>> We have a large database with over 1000 stored
procedures,
>> we need to determine when last these procedures where
used
>> so we can remove and redundant/unused procedures. Is
>> there any way to do this using SQL Server 2000?
>> Thanks,
>> Stephen
>
>.
>