SQL trigger on column

15 pts.
Tags:
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

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Discuss This Question: 3  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • TomLiotta
    What database is it? What platform? (And perhaps what OS release?) Tom
    125,585 pointsBadges:
    report
  • Lkjh1234
    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.
    15 pointsBadges:
    report
  • carlosdl
    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.
    69,605 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following