I am trying to write a trigger that inserts some data into another table in the baandb.

CREATE TRIGGER SALESORDER_INSERT_TRG
ON ttdsls040600 /* Sales Order Header Table */
FOR INSERT
AS

BEGIN

INSERT INTO tblSalesOrderHeader(t_orno) values (654398)

END

When I install this trigger I get the error message stated in the title of this post.

Can someone explain to me what I am failing to understand?

Thanks

Ok.. I have that simple insert working.

Not really sure why it wasn't working before but it is now :)