Audit Logs in SQL SERVER ?

Hi,
Does SQL provide an Audit log on who is accessing which database and what's
being done on each table that's kept in certain system tables or is there any
stored procedures to keep track of this ?
tks & rdgs
maxzsimHi maxzsim
I think SQL Profiler can help you in achieving this task.
best Regards,
Chandra
http://chanduas.blogspot.com/
---
"maxzsim" wrote:
> Hi,
> Does SQL provide an Audit log on who is accessing which database and what's
> being done on each table that's kept in certain system tables or is there any
> stored procedures to keep track of this ?
> tks & rdgs
> maxzsim|||Hi Chandra,
is there any alternative besides the SQL Profiler ?
rdgs
"Chandra" wrote:
> Hi maxzsim
> I think SQL Profiler can help you in achieving this task.
>
> --
> best Regards,
> Chandra
> http://chanduas.blogspot.com/
> ---
>
> "maxzsim" wrote:
> > Hi,
> >
> > Does SQL provide an Audit log on who is accessing which database and what's
> > being done on each table that's kept in certain system tables or is there any
> > stored procedures to keep track of this ?
> >
> > tks & rdgs
> > maxzsim|||Hi maxzsim
You can use NT EventLog for this, but it will not give you all the
information that you require. I prefer using SQL Profiler for this purpose.
best Regards,
Chandra
http://chanduas.blogspot.com/
---
"maxzsim" wrote:
> Hi Chandra,
> is there any alternative besides the SQL Profiler ?
> rdgs
> "Chandra" wrote:
> > Hi maxzsim
> > I think SQL Profiler can help you in achieving this task.
> >
> >
> > --
> > best Regards,
> > Chandra
> > http://chanduas.blogspot.com/
> > ---
> >
> >
> >
> > "maxzsim" wrote:
> >
> > > Hi,
> > >
> > > Does SQL provide an Audit log on who is accessing which database and what's
> > > being done on each table that's kept in certain system tables or is there any
> > > stored procedures to keep track of this ?
> > >
> > > tks & rdgs
> > > maxzsim|||Hi,
I recommend you to enable server side tracing if the server is Production.
This will use the resouce very less compared to SQL Profiler.
Have a look into the below great article from Vyas on server side tracing
with examples to configure:-
http://vyaskn.tripod.com/server_side_tracing_in_sql_server.htm
Thanks
Hari
SQL Server MVP
"maxzsim" <maxzsim@.discussions.microsoft.com> wrote in message
news:6485BF63-1708-4D96-B245-E056D12EEEAD@.microsoft.com...
> Hi,
> Does SQL provide an Audit log on who is accessing which database and
what's
> being done on each table that's kept in certain system tables or is there
any
> stored procedures to keep track of this ?
> tks & rdgs
> maxzsim|||An alternative might be to look at many of the transaction log analyzers out
there:
http://www.apexsql.com/sql_tools_log.htm
http://www.lumigent.com/products/entegra.html
http://www.logpi.com/
to name but three.
"maxzsim" wrote:
> Hi,
> Does SQL provide an Audit log on who is accessing which database and what's
> being done on each table that's kept in certain system tables or is there any
> stored procedures to keep track of this ?
> tks & rdgs
> maxzsim|||It might be worth mentioning that SELECT cannot be obtained from the transaction log. So the tools
that can audit reads do this using a background profiler trace...
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Scrat" <Scrat@.discussions.microsoft.com> wrote in message
news:19322556-D9C2-467F-ABBA-BC1C8845E222@.microsoft.com...
> An alternative might be to look at many of the transaction log analyzers out
> there:
> http://www.apexsql.com/sql_tools_log.htm
> http://www.lumigent.com/products/entegra.html
> http://www.logpi.com/
> to name but three.
> "maxzsim" wrote:
>> Hi,
>> Does SQL provide an Audit log on who is accessing which database and what's
>> being done on each table that's kept in certain system tables or is there any
>> stored procedures to keep track of this ?
>> tks & rdgs
>> maxzsim