Post reply

How to capture user activity on TABLE OBJECT like SELECT,INSERT,UPDATE

  • November 1, 2004 at 10:03 am

    #162507

    HI EVERY BODY

    I have requirement like this "I HAVE A TABLE IN MY DATABASE WHICH IS HAVING REFERENTIAL INTEGRITY,Now i have to capture the user activities like INSERT,SELECT,UPDATE on that table with out adding any column to that table with out addiging any table to that database i have to capture the user activities?

  • November 2, 2004 at 6:41 am

    #528602

    You'll have to use the profiler. When starting a trace you can add filters (in trace properties / filters) such as user name, appname, events, database, objects...

    Just ask if you need more help on this matter.

  • November 15, 2004 at 1:07 pm

    #530173

    In addition to profiler (which can output to file if you prefer not to create a table), if you would like to get an email when those activities happens you could use triggers (except select).

Viewing 3 posts - 1 through 2 (of 2 total)

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