Name the triggers which support SQL Server 2000

Question

Name the triggers which support SQL Server 2000?

Answer 1

SQL Server 2000 supports AFTER and INSTEAD OF triggers only. The BEFORE triggers cannot be supported by any SQL server. A table might have one or more AFTER triggers for update, insert and delete actions; AFTER triggers might not be assigned to views. A view or table might have at most one INSTEAD OF trigger for each and every triggering action of update, insert or delete.