I am using a SQL Trigger that is getting inactivated at random times. The SQL Server and the SQL Services are not being restarted or rebooted as they are attached to a live environment. There is no expiration enabled. Any ideas? I know it is not a lot of information to give. Version 7.0.3. I do not see any log file that would help me.

Ok, what about increasing Retry times on error?

---

There is no retry option for the SQL Trigger.

You are right. We probably need to implement that. I am moving this topic to Feature requests.

---

Thanks...in the mean time i changed the command timeout from the default 0 to 600...who knows...i will update if seems to work.

Just an update...i am on Version 7.0.5 latest beta and this inactivation has seemed to go away. In the previous reply i had stated i changed the command timeout...this did not fix the inactivation issue either in the older versions.