Monitor Object Access


I would like to remove an index from my database, but I need to verify
that it is not being accessed before I do that.

I tried running Profiler, but it doesn't seem to be giving me the
information I need. I put in a filter for ObjectName, but it seems to
be ignoring it - i get several entries in the profile trace, but no
value in the ObjectName column.

Is there an easy way to monitor for object access?

Thanks so much!

SQL Servef 2000 SP4
(I also have 2005, SP2, if there's a better way to do this with 2005)

.

Relevant Pages

  • Re: find out a user/account permission...
    ... quotenameAS ObjectName ... else 0 end) as 'CREATE DATABASE' ... Mark Allison, SQL Server MVP ... > my company remove any email attachment from outside automatically. ...
    (microsoft.public.sqlserver.server)
  • Re: find out a user/account permission...
    ... What follows -- thanks to Mark -- is the script he attached.... ... quotenameAS ObjectName ... else 0 end) as 'CREATE DATABASE' ... >> Mark Allison, SQL Server MVP ...
    (microsoft.public.sqlserver.server)
  • Re: Why does msaccess.exe persist sometimes?
    ... meant to refer to anytime you do a "Set ObjectName = xxxx" code step in the ... <MS ACCESS MVP> ... Could you give me an example of what you mean by "a reference to ... the database," and the syntax for the associated ...
    (microsoft.public.access.gettingstarted)