Home > IT Answers > SQL Server > SQL trigger on column
Lkjh1234
15 pts.
 SQL trigger on column
SQL Server, SQL Trigger
Table have delete and update trigger. How to identify which columns are affected by this triigers? or  which column have  triggers ?

Software/Hardware used:
no
ASKED: May 9, 2012  4:46 AM
UPDATED: May 9, 2012  3:32 PM
RELATED QUESTIONS
Answer Wiki:
Last Wiki Answer Submitted:  Be the first to answer this question.
All Answer Wiki Contributors:  Be the first to answer this question.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

What database is it? What platform? (And perhaps what OS release?)

Tom

TomLiotta
 108,205 pts.
 

Hi Tom,
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.

Lkjh1234
 15 pts.
 

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.

carlosdl
 63,535 pts.