Unanswered: how to implement a Multirow insert trigger?
I have the following trigger:
Create trigger [dbo].[new_Location]
insert into dbo.tbl_Events ( Event_Id , Location_Id )
SELECT NewID(), Inserted.Location_Id
Which works fine on single-record inserts, however, on multiple row inserts to tbl_Events (batch load) the trigger doesn't fire. How can I modify it to work for multiple record inserts?
Are you using BCP?
I don't think BCP fires triggers.
Also possible that some command in your batch process is temporarily disabling the trigger.
Either way, there is nothing wrong with your trigger. It should fire on any insert.
If it's not practically useful, then it's practically useless.