Triggers & SQL Server 2000

[stabiplan]

Hello,

I found out I can add a trigger to a table. Doing so, I wonder howto:
- Set what kind of trigger it is (delete, update)
- Set the SQL for the trigger

Now only this is generated:
CREATE TRIGGER TR_ONDELETE
ON CUSTOMER

;

Feeding the script to SQL server query analyzer gives me:
'CREATE TRIGGER' must be the first statement in a query batch.
(I use one script for all tables)


Trying to be smart, I created a trigger in a SQL database and reverse engineered it into a model. Unfortunately the trigger does not show up in the model.

What can I expect from trigger modelling in EA?

Regards,

Rob

[hd]

Improvements in reverse engineering triggers is on our list of todo's.  

At the moment, add the body of the trigger to its Notes field.