how do I determine what tables/views are being accesed

How can i determine what tables/views are being accesed,
when, how and by who. I have attempted using profiler but
with no joy as yet.
Hi,
You can use a 3rd party tool as well. Tool is Entegra by Lumigent
(www.lumigent.com).
Did you tried the Event clause -- TSQL -- Batch starting option in Profiler
? That gives you all the DML commands executed / duration and
user who executed.
Thanks
Hari
MCDBA
"Mat" <anonymous@.discussions.microsoft.com> wrote in message
news:175ec01c418a5$3164da20$a401280a@.phx.gbl...
> How can i determine what tables/views are being accesed,
> when, how and by who. I have attempted using profiler but
> with no joy as yet.
|||That only gives me the sp executed, i need to know what
tables/views are used.
basicly i want to know when a table/view is accesed as i
have identified several possible redundant tables and i
want to make sure that they never get accessed before i
remove them

>--Original Message--
>Hi,
>You can use a 3rd party tool as well. Tool is Entegra by
Lumigent
>(www.lumigent.com).
>Did you tried the Event clause -- TSQL -- Batch starting
option in Profiler
>? That gives you all the DML commands executed / duration
and
>user who executed.
>
>Thanks
>Hari
>MCDBA
>
>
>"Mat" <anonymous@.discussions.microsoft.com> wrote in
message
>news:175ec01c418a5$3164da20$a401280a@.phx.gbl...
but
>
>.
>