What database is it? What platform? (And perhaps what OS release?)
I am working on win xp, SQL server 2k8, it’s our project database.
We have 10 database which contains table which have insert,update and delete trigger. i sucessfully identified the table which have these three trigers. now i want to identify the columns within that database table(which hve 3 above mentioned triggers) which will be editable/ or user can update. as per table trigger.
I guess you could see the columns being monitored by looking at the trigger code.
You can use the sp_helptext procedure to see the code.