Monitor SQL commands

I need to monitor who is sending what SQL commands when. Is there any way
to do this?
Usarian Skiff
SQL Profiler.
comes with sql server...of course it depends on how they are connecting
to the database (if everyone connects as the same user, which i have
seen, then it is going to be more difficult to track down).
In enterprise manager > Tools > SQL Profiler
File > New > Trace
connect to server of your choice
choose one of the templates.
go to the events tab and select anything else you want to know (there
is a TSQL section and security audit section, both of which you will
need to answer your questions)
you can then set up any filters that you think apply.
then run it.
you might need to dink around with it a bit to get the hang of it, but
it is a very powerful tool and is a must for maintaining production
environments.
hth,
hans nelsen
|||Thanks Much.
Unfortunately, our control software does in fact use a single db login for
every workstation, so it will be a pain indeed, but, as you pointed out, a
necessary pain. Thanks again!
Usarian M. Skiff
"Hans Nelsen" <hnelsen@.owh.com> wrote in message
news:1110585962.109808.283360@.o13g2000cwo.googlegr oups.com...
> SQL Profiler.
> comes with sql server...of course it depends on how they are connecting
> to the database (if everyone connects as the same user, which i have
> seen, then it is going to be more difficult to track down).
> In enterprise manager > Tools > SQL Profiler
> File > New > Trace
> connect to server of your choice
> choose one of the templates.
> go to the events tab and select anything else you want to know (there
> is a TSQL section and security audit section, both of which you will
> need to answer your questions)
> you can then set up any filters that you think apply.
> then run it.
> you might need to dink around with it a bit to get the hang of it, but
> it is a very powerful tool and is a must for maintaining production
> environments.
> hth,
> hans nelsen
>