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.

--
Erland Sommarskog, SQL Server MVP, sommar@algonet.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp