RE: auditing database/server activities

From: jason (jason_at_discussions.microsoft.com)
Date: 12/17/04

  • Next message: Dan Guzman: "Re: SA Login Changin???" 
    Date: Thu, 16 Dec 2004 16:43:04 -0800

    dwh2200,

    the more i think about your comment the more i like it. how difficult a
    task do you think it would be to do something like this?

    "dwh2200" wrote:

    > Fair enough. If you have the trace dump output to a table, you can get there
    > from where I left it by putting a scheduled job out there (or a trigger) that
    > can read the records and report back any information you want to have it
    > alert for via email.
    >
    > "jason" wrote:
    >
    > > dwh,
    > > with the approach you are employing, it requires you manually looking over
    > > the logs...right?
    > > I am looking for a way to set up a system that will automatically alert our
    > > DBAs of any activity we configure it to. Nor require any ongoing manually
    > > effort.
    > >
    > > "dwh2200" wrote:
    > >
    > > > I'm currently using a sql profiler trace to track changes made on the
    > > > database. Not really tracking inserts/updates/deletes, just the DDL and
    > > > security stuff. The Security Audit group of events in profiler give you most
    > > > of what you'd be interested in. For digging through transaction logs,
    > > > Lumigent's Log Explorer isn't a bad tool. For some extra $$, Entegra might
    > > > be an option as well.
    > > >
    > > >
    > > > "jason" wrote:
    > > >
    > > > > with increased concern of security these days. what are people using to
    > > > > audit the activities on a sql server database?
    > > > >
    > > > > if they use in the box tools, is the audit trail managable?
    > > > >
    > > > > are people using a 3rd party tool to do sql server auditing?
    > > > >
    > > > > thanks

  • Next message: Dan Guzman: "Re: SA Login Changin???"