There are few ways to do it. The first way is to start up profiler
or set up server side trace and filter the textdata column with the
table's name. This way you'll see all activities on the table
including select statements.
Another way is to create stored procedure for insert, update and
delete statement. In the stored procedures you can insert a record
into log table with the details that you need. You can revoke insert,
update and delete statement on the table and let users work with the
stored procedure only. Notice that anyone that belongs to db_owner
role or sysadmin server role will still be able to work directly with
Another option is to create trigger on the table for update, insert
and delete. In the trigger you can log anything into a log table.
This way you will be able to log all data modification operations
regardless the way that it was done (direct SQL statement or through
On Feb 3, 9:07 am, "prashant" <firstname.lastname@example.org> wrote: