CODEWITHSUNDEEP
sql-server-2008triggersinsert
user3124029
user3124029

Reputation: 3

SQL Server trigger not working while inserting values

Is it possible the insert trigger is not run while the values are inserted on the table? Anybody was experience this?

Upvotes: 0

Views: 886

Answers (1)

Randy Minder
Randy Minder

Reputation: 48402

No it's not possible, if you have the trigger set up correctly. Are you sure you've indicated you want the trigger to fire on an Insert? You have the option of specifying a trigger to fire on an Insert, Update, Delete or any combination.

Or the trigger could be disabled. Or there could be a Return statement in the first line of the trigger. I've seen people do that, as a way to disable a trigger.

Also, if you are inserting multiple rows into the table, you need to make sure your trigger is created correctly to handle that. Handling multiple inserts can be a bit more complicated than handling a single insert, and unexpected results could occur if you are not aware of the difference.

Upvotes: 2

Related Questions