How to trace transactions against a table

Posted on 2009-02-09
Last Modified: 2012-08-14
A number of records in a table have been periodically removed. How can I execute a trace on the table to check what is happening to these records?

Question by:NickyPower
    LVL 57

    Expert Comment

    by:Raja Jegan R
    You can write a trigger on that table to perform audit on that particular table and capture User name along to track what happened to the records.

    Author Comment

    I am not a SQL Server expert so i am not too sure how to start writing a trigger...
    LVL 57

    Accepted Solution

    check out the link below:

    Create three triggers for INSERT, DELETE and UPDATE to capture those details if anything is happening across that table.

    Featured Post

    IT, Stop Being Called Into Every Meeting

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    Join & Write a Comment

    Suggested Solutions

    There are some very powerful Data Management Views (DMV's) introduced with SQL 2005. The two in particular that we are going to discuss are sys.dm_db_index_usage_stats and sys.dm_db_index_operational_stats.   Recently, I was involved in a discu…
    In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
    Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…
    In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor ( If you're interested in additional methods for monitoring bandwidt…

    755 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    23 Experts available now in Live!

    Get 1:1 Help Now