Post reply

event notifications

  • June 8, 2011 at 12:34 pm

    #104073

    Hi,

    Can Anybody give an example of using SQL Server 2005 event notifications to keep track of DML operations and how it works actually?

    Any help would be greatly appreciated.

    Regards,

  • June 8, 2011 at 3:26 pm

    #1335972

    There's a few examples in Book Online, but the key point is the Event Notifications is that there are no Events for DML.

    To see all of the event types for which you can create an Event Notification:

    SELECT * FROM sys.event_notification_event_types

    Eddie Wuerch
    MCM: SQL

  • June 9, 2011 at 5:08 am

    #1336173

    Hi Eddie,

    Thanks for the quick response. That is what i have been checking in books online as well.

    Is there any workaround to trace/audit the DML operations from using sql profiler? is there any specific so that i can use the profiler to achieve this task. Basically collecting profiler is too much of information. Do we have any spefic events as such in sql profiler as such so as to audit the DML operations on a specific database?

    Thanks in Advance.

  • June 9, 2011 at 8:56 am

    #1336385

    Profiler will generate a lot more data than you need. You could load your trace files into a table as needed and delete what you do not need however that's a lot of work. The problem has been solved more directly with the introduction of Change Tracking and Change Data Capture in SQL Server 2008. Upgrading may not be in the cards for you, but it could be ammunition when asking.

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

  • June 10, 2011 at 6:13 am

    #1336912

    Thank you very much.

  • July 22, 2011 at 4:51 am

    #1356928

    do we have the event notifications for sql 2008 apart from CDC(change data capture)?

  • July 22, 2011 at 6:38 am

    #1357009

    Oracle_91 (7/22/2011)

    do we have the event notifications for sql 2008 apart from CDC(change data capture)?

    Yes. Event Notifications are there...but as Eddie pointed they do not cover DML events.

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

  • July 22, 2011 at 12:49 pm

    #1357251

    Thanks for the confirmation.

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply