SEO

#1 (**permalink**) 02-28-2008, 06:47 PM

I created a trigger in the "source table" that will "feed" and second
table. The trigger is as follows:
CREATE TRIGGER [FeedToP21] ON dbo.FromUPS
FOR INSERT
AS
Declare @Count int

Select @Count = Count(*) from Inserted
If @Count > 0
Begin
Insert into ToP21
Select i.* From Inserted i
Left Join ToP21 t
on i.recnum = t.recnum
Where t.recnum is null
End

If @@ERROR != 0
Rollback Tran

A record was created in the "source table" via ODBC, however, the
trigger does not seem to have fired to create the record in the second
table.
If I create a record manually using SQL Server Enterprise Manager
within the "tableview" the trigger fires and a duplicate record is
created in the second table.

Is there a fix for this problem?

Thank you in advance.

#2 (**permalink**) 02-28-2008, 06:49 PM

Hi

There is not enough detail to say why this is not being called and how the
transactions are being handled and what data is not being written.

You may want to use profiler to check the calls and possible save your
commands to a sql script that can be run in Query Analyser. You could use
Raiserror instead of rolling back the transaction to see if that condition
is reached or to return debug information.

John

"Jack" <jackso95@hotmail.com> wrote in message
news:ba6102e.0311131522.4c89911@posting.google.com ...
> I created a trigger in the "source table" that will "feed" and second
> table. The trigger is as follows:
> CREATE TRIGGER [FeedToP21] ON dbo.FromUPS
> FOR INSERT
> AS
> Declare @Count int
>
> Select @Count = Count(*) from Inserted
> If @Count > 0
> Begin
> Insert into ToP21
> Select i.* From Inserted i
> Left Join ToP21 t
> on i.recnum = t.recnum
> Where t.recnum is null
> End
>
> If @@ERROR != 0
> Rollback Tran
>
> A record was created in the "source table" via ODBC, however, the
> trigger does not seem to have fired to create the record in the second
> table.
> If I create a record manually using SQL Server Enterprise Manager
> within the "tableview" the trigger fires and a duplicate record is
> created in the second table.
>
> Is there a fix for this problem?
>
> Thank you in advance.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

Create trigger not firing via ODBC