Answers that are based on theory but not borne out by empirical results are flawed either in the way the question is posed or the theory itself.

Sorry, but I completely...

I just ran a similar query on a SQL 2000 database and it worked. That is the way I answered.

I see that others have indicated that for...

MS On-line help for SQL lists three Types of DML triggers: After, Instead of and CLR.

ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/2e3f74a7-05b6-445a-8156-4aa10232c324.htm

The only one in dispute is CLR which according to the authors of the question...

I'll post my two cents worth.

The question asks "How many types of DML triggers in SQL are present? (DML - Data Modification Language)" - it doesn't ask "How many types...

Maybe its semantics, but where I come from "direct export" means I can choose it as an option.  Since an .mdb is not an option but a two step process...

two points of clarification -

1) The HR group is not defined as a separate Active Directory Security group - they belong to the same security group that the normal users...

This question made me think of another closely related situation that I have here for which I don't have a ready solution.

I work in an organization of over 300 employees...