Wednesday, March 7, 2012

Monitor SQL server activity

Hi,
This question has been asked thousand of times I'm sure
but anyway:
Does it exist an EASY way to monitor, or trace, or log the
activity on a specific database using sql server ?
In fact, I'd like to record all the SELECT made on a
database (having insert, delete, update would also be
great), without using third party tool and having a
readable log file.
Thanks,
OlivierHello,
Have you considered setting up a SQL Profile, and
configuring it to that one database, SQL Commands only ?
Thanks
Peter
>--Original Message--
>Hi,
>This question has been asked thousand of times I'm sure
>but anyway:
>Does it exist an EASY way to monitor, or trace, or log
the
>activity on a specific database using sql server ?
>In fact, I'd like to record all the SELECT made on a
>database (having insert, delete, update would also be
>great), without using third party tool and having a
>readable log file.
>Thanks,
>Olivier
>.
>

No comments:

Post a Comment