by Brian Bake » Fri, 01 Jan 1999 04:00:00
I tried using SQL Trace to see if it was being fired, but it doesn't show
any mention of it there. I also tried dropping and recreating the trigger.
Any suggestions on how to troubleshoot this problem?
Brian Baker
by Tony Rogerso » Fri, 01 Jan 1999 04:00:00
The trigger won't appear in SQL Trace, Trace only captures the SQL batch
that was sent to SQL Server.
To determine if the trigger is being fired, modify it and put some debug
code in there, such as a select statement or print then try an insert.
--
Hope the above helps.
Tony Rogerson MCP, MS SQL Server MVP
Torver Computer Consultants Ltd
London, England.
Quote:>I've got an insert trigger on a table that doesn't seem to be firing. The
>trigger is an autonumber emulator, created by the SQL Server Browser (part
>of the MS Access Upsizing Tools).
>I tried using SQL Trace to see if it was being fired, but it doesn't show
>any mention of it there. I also tried dropping and recreating the trigger.
>Any suggestions on how to troubleshoot this problem?
>Brian Baker
by Mohamed A. Zaian » Mon, 04 Jan 1999 04:00:00
regards
Mohamed Zaiani
MCSE, MCSD, MCT, MCP+I, CLP, SCJP
1. bulk insert triggers not fired for update
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. NT is much slower than 95 with Paradox BDE, Delphi 2.01
3. bulk insert not firing insert triggers
4. Consistent No Of Columns Per Row
5. Insert Trigger is not firing
6. US-CA-DBA
7. Bcp Not firing Insert Trigger
8. nonfatal internal error (severity 18)
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