Thanks for the answer. I had briefly thought of the Profiler but not
knowing much about it, didn't know if it's suitable for this length of
tracking, which would probably be anything from a couple of months, to
a permanent type of thing. But I'll look into it more.


Erland Sommarskog <sommar@algonet.se> wrote in message news:<Xns93F321C532A4Yazorman@127.0.0.1>...
> Gary DeRousse (garyderousse@yahoo.com) writes:
> > We're using SQL Server 2000 and we'd like to be able to track our view
> > usage to tell which of our views get used most often. This will help
> > us determine which views we need to concentrate on first for
> > optimizing, indexing, etc... Does anybody know if there's a way to
> > tell when a view is opened?
>
> I would guess the Profiler is your best bet.