Hi ,
We can do audit trial through triggers in sql server , but oracle itself
having one feature for audit trialing with out using triggers, can any one
suggests me whether its possible in sql server with out using triggers.With SQL Server tools, you can use Profiler.
There are some 3rd party tools, for example Entegra from Lumigent
(http://www.lumigent.com/).
--
Dejan Sarka, SQL Server MVP
Associate Mentor
Solid Quality Learning
More than just Training
www.SolidQualityLearning.com
"sekhar" <sekhar@.discussions.microsoft.com> wrote in message
news:072C59CD-A1DF-4BF3-BC02-33FFFA0F15CF@.microsoft.com...
> Hi ,
> We can do audit trial through triggers in sql server , but oracle itself
> having one feature for audit trialing with out using triggers, can any one
> suggests me whether its possible in sql server with out using triggers.|||Hi,
Also see .. C2 Auditing.
C2 Auditing option to review both successful and unsuccessful attempts to
access statements and objects. See books online for
more details.
Thanks
Hari
MCDBA
"Dejan Sarka" <dejan_please_reply_to_newsgroups.sarka@.avtenta.si> wrote in
message news:eyNCQ41gEHA.4092@.TK2MSFTNGP10.phx.gbl...
> With SQL Server tools, you can use Profiler.
> There are some 3rd party tools, for example Entegra from Lumigent
> (http://www.lumigent.com/).
> --
> Dejan Sarka, SQL Server MVP
> Associate Mentor
> Solid Quality Learning
> More than just Training
> www.SolidQualityLearning.com
> "sekhar" <sekhar@.discussions.microsoft.com> wrote in message
> news:072C59CD-A1DF-4BF3-BC02-33FFFA0F15CF@.microsoft.com...
> > Hi ,
> > We can do audit trial through triggers in sql server , but oracle itself
> > having one feature for audit trialing with out using triggers, can any
one
> > suggests me whether its possible in sql server with out using triggers.
>
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment