Is it Possible to Disable the Triggers in the SQL Server 2012 for the Particular Stored Procedure Run While it will be active in the other Processes?

Asked Mar 17 '17 at 07:48

Active Mar 17 '17 at 11:37

Viewed 31 times

Is it possible to disable the triggers for a particular stored procedure run while it will be active in the other processes?

Like if

update Table A 
having Update Trigger TrA with a SP

Trigger will not work but if I do the update manually will the trigger work? Any property for the SP.

edited Mar 17 '17 at 11:37

asked Mar 17 '17 at 07:48

Gaurav Shivhare

1

Triggers are product specific. Please [edit] your question to add a tag identifying your product. – Damien_The_Unbeliever Mar 17 '17 at 07:54
if it is for sql server,you could start with something like ,knowing proc name and rolling back:http://stackoverflow.com/questions/14467961/how-to-get-the-stored-procedure-name-from-a-trigger-when-an-update-operation-was – TheGameiswar Mar 17 '17 at 07:59
@Damien_The_Unbeliever, Triggers are actually defined by the ISO/ANSI SQL standard. (But most products have their own versions.) – jarlh Mar 17 '17 at 08:20
Updated,Please Suggest for the SQL Server – Gaurav Shivhare Mar 17 '17 at 11:33
@TheGameiswar Thanks can u please elavorate? – Gaurav Shivhare Mar 17 '17 at 11:34

0 Answers0