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?

Thanks,

Gary