Board index MS SQL Server

Bcp Not firing Insert Trigger

Bcp Not firing Insert Trigger

Post by Michael Meye » Sat, 11 Mar 2000 04:00:00



Is there a way to when loading a table via bcp to have the insert trigger
fire?

Thanks

 
 
 
Top

Bcp Not firing Insert Trigger

Post by Neil Pik » Sat, 11 Mar 2000 04:00:00


Michael - not with current SQL Server releases.

Quote:> Is there a way to when loading a table via bcp to have the insert trigger
> fire?

> Thanks

 Neil Pike MVP/MCSE.  Protech Computing Ltd
 (Please reply only to newsgroups)
 SQL FAQ (420 entries) see
 forumsb.compuserve.com/vlforums/UK/default.asp?SRV=MSDevApps (sqlfaq.zip - L7
- SQL Public)
 or www.ntfaq.com/sql.html
 or www.sql-server.co.uk
 or www.mssqlserver.com/faq

 
 
 
Top

1. bulk insert not firing insert triggers

I'm finding that update triggers don't get fired when using bulk insert.
Is this a known problem or a "feature" of bulk insert?  Will update
level triggers work on a bulk inserted table?

2. JSP login

3. bulk insert triggers not fired for update

4. Access 2002/SQL 2000 Constraints

5. Insert Trigger is not firing

6. Sample Application using Web Services on DB2 and WebSphere

7. Insert trigger not firing

8. SQL client on NT server

9. trigger does not fire when inserting via DTS

10. SQL Server 2000 bug: DTS import does not fire insert trigger

11. Trigger not firing for multiple insert

12. Triggers do not fire on Insert Into ....

13. trigger does not fire when inserting via DTS


All times are UTC
Board index