I'm with a very similiar problem and I tried to test this last code to check if it solves my problem. But it doesn't helped me.

The difference between the scenarios...

Thank you all for the help. The solution using stored procedure seems to be working and we choose it to fix this problem for now, even though a better solution...

Hi Grant,

thank you for answer me. I read the article you told me, but it only works for NHibernate and Im using Hibarnate (the property of hibernate.cfg.xml is not...

Yes, the management studio is ad-hoc SQL. But the app is not using a procedure, I know that the app uses hibernate to send the query and the value of...

Hi Gail,

thank you for answer me. I've attached the informations you asked me.

Nat