when I created the trigger I am getting below error when I am testing

SQL STATE=42S02

MICROSOFT SQL NATIVE CLIENT

INVALID OBJECT NAME 'UPDATED'

NO CHANGES MADE TO DATABASE

CAN YOU HELP ME...

I don't have updated trigger but I have insert trigger

create trigger jam_spu_csp_insert on customer_special_pricesafter insert asbegininsert into jam_spu ( customer_id, location_number, seq_num )SELECT customer_id, location_number, seq_num FROM insertedendgo

CAN I WRITE LIKE THIS

create trigger jam_spu_csp_changed

on customer_special_prices

after

update

as

begin

IF UPDATE(price_table)OR UPDATE (bracket)

insert into jam_spu ( customer_id, location_number, seq_num )

select customer_id,location_number, seq_num FROM updated

end

go

Are price_table, bracket fields from customer_special_prices table ?

Yes those columns are from customer_special_prices table

Do you have any idea of what "order 2" means ?

I have no idea but i...

Thank you very much can you tell me rest of the two triggers

create trigger jam_spu_csp_changed

after update of price_table, bracket

order 2 on customer_special_prices

referencing old as old_name

for each row

begin

insert into...

Create Trigger jam_spu_csp_insert

on dbo.customer_special_prices

After Insert

AS

Begin

Set nocount on;

insert into jam_spu ( customer_id, location_number, seq_num )

values ( new_name.customer_id, new_name.location_number, new_name.seq_num )

end

go

error

Server: Msg 128, Level 15, State 1,...