problem with triggers

ghiboz · **Joined:** Wed Jun 14, 2006 10:31 am **Posts:** 6

Hi all!
I have this problem
in my sql server 2005 express edition table I have a trigger that update another table when the table have an insert/update.
if I insert a record with NHibernate gives an error due to the fact that are 2 records updated/inserted and not one...
how can I fix this??

thanks again!

here is my code:

Code:

session.Save(myTableObject);
transaction.Commit();
session.Close();

thanks in advance!

ghiboz

merge_s.rottem · **Joined:** Tue Aug 23, 2005 5:52 am **Posts:** 335

You need to add SET NOCOUNT ON at the beginning of your trigger.

Cheers,

Symon.

ghiboz · **Joined:** Wed Jun 14, 2006 10:31 am **Posts:** 6

merge_s.rottem wrote:

You need to add SET NOCOUNT ON at the beginning of your trigger.

Cheers,

Symon.

thanks mate!
it works!!
another question... i looked into the nhibernate source... how can I do to to use ExecuteUpdateResultCheckStyle.None instead of ExecuteUpdateResultCheckStyle.Count??

thanks again!