• You can do that with system side tracing. All you need to trace the events regularly using the system sided stored procedures.

    Cheers,
    Sugeshkumar Rajendran
    SQL Server MVP
    http://sugeshkr.blogspot.com