Auditing on SQL-server.

Hello Readers,
I am looking for ways of auditing in SQL-server.
Using Google I am a bit overwhelmed with solutions.
At the moment we are looking at limited auditing, where
the following has to be audited :
user, date_time, some specific database mutations.
Offcourse we want it :
Fast, Good, Cheap.
My thought up to now :
1. Logging of SQLserver (not too suitable for reading).
2. Profiler (not too suitable for continues use and rather limited for
data).
3. Triggers (Expensive in resources ?)
4. Special tools. (This is the part I am overwhelmed with).
Any good pointers ?
(Google search words, specific sites, solutions ?)
Thanks,
Ben Brugman
Found this link :
http://www.akadia.com/services/sqlsr..._auditing.html
More suggestions are welcome.
Ben
"ben brugman" <ben@.niethier.nl> wrote in message
news:uLqgP4d5FHA.4076@.tk2msftngp13.phx.gbl...
> Hello Readers,
> I am looking for ways of auditing in SQL-server.
> Using Google I am a bit overwhelmed with solutions.
> At the moment we are looking at limited auditing, where
> the following has to be audited :
> user, date_time, some specific database mutations.
> Offcourse we want it :
> Fast, Good, Cheap.
> My thought up to now :
> 1. Logging of SQLserver (not too suitable for reading).
> 2. Profiler (not too suitable for continues use and rather limited for
> data).
> 3. Triggers (Expensive in resources ?)
> 4. Special tools. (This is the part I am overwhelmed with).
> Any good pointers ?
> (Google search words, specific sites, solutions ?)
> Thanks,
> Ben Brugman
>
|||Depends on exactly what you need to audit. Some of the less expensive 3rd
party tools such as
http://www.red-gate.com/products/SQL...scue/index.htm
are quick and easy. At those prices you can't develop a comparable auditor
yourself for the price. In SQL 2005 it gets even easier with the new DDL
triggers and information available via triggers. Here are some more
options:
http://www.aspfaq.com/show.asp?id=2496
http://www.aspfaq.com/show.asp?id=2448
Andrew J. Kelly SQL MVP
"ben brugman" <ben@.niethier.nl> wrote in message
news:uLqgP4d5FHA.4076@.tk2msftngp13.phx.gbl...
> Hello Readers,
> I am looking for ways of auditing in SQL-server.
> Using Google I am a bit overwhelmed with solutions.
> At the moment we are looking at limited auditing, where
> the following has to be audited :
> user, date_time, some specific database mutations.
> Offcourse we want it :
> Fast, Good, Cheap.
> My thought up to now :
> 1. Logging of SQLserver (not too suitable for reading).
> 2. Profiler (not too suitable for continues use and rather limited for
> data).
> 3. Triggers (Expensive in resources ?)
> 4. Special tools. (This is the part I am overwhelmed with).
> Any good pointers ?
> (Google search words, specific sites, solutions ?)
> Thanks,
> Ben Brugman
>