triggers with nhibernate

Question

Hi

I want to implement auditing using triggers for my web application. I noticed that nhibernate gives error on insert/update single record on table where audit trigger is used. I tried SET NOCOUNT ON option and it worked for me. I need to know what is the disadvantage of using this option with NHibernate. If its not good practice then what could be an easy workaround of it.

Thanks, Asif