Triggers

Informix^® and Microsoft™ SQL SERVER provide triggers with similar features, but the programming languages are totally different.

Microsoft SQL SERVER does not support "BEFORE" triggers.

Microsoft SQL SERVER does not support row-level triggers.

Solution

Informix triggers must be converted to Microsoft SQL SERVER triggers "by hand".

Important: To ensure that SQL SERVER generates only necessary result sets in triggers, use the SET NOCOUNT ON at the beginning of your triggers. See SQL SERVER documentation for more details about SET NOCOUNT ON.