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 <so****@algonet.se> wrote in message news:<Xn*********************@127.0.0.1>...
Gary DeRousse (ga**********@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.