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...[vbcol=seagreen]
> 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...
one
>
Showing posts with label itselfhaving. Show all posts
Showing posts with label itselfhaving. Show all posts
Thursday, March 8, 2012
audit trial
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...
one[vbcol=seagreen]
>
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...
one[vbcol=seagreen]
>
Subscribe to:
Posts (Atom)