Wednesday, March 7, 2012

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 an
y
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:
[vbcol=seagreen]
> Hi maxzsim
> I think SQL Profiler can help you in achieving this task.
>
> --
> best Regards,
> Chandra
> http://chanduas.blogspot.com/
> ---
>
> "maxzsim" wrote:
>|||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:
[vbcol=seagreen]
> Hi Chandra,
> is there any alternative besides the SQL Profiler ?
> rdgs
> "Chandra" wrote:
>|||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_sid..._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 transac
tion 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...[vbcol=seagreen]
> An alternative might be to look at many of the transaction log analyzers o
ut
> 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:
>

No comments:

Post a Comment