With SQL Clustering, on a failover the connections are in fact lost unfortunately. The SQL service is actually restarted on the new server. So you will see a...

So, you da man Chuck Hottle. We are apparently setting IMPLICIT_TRANSACTION ON all throughout our code. I brought it up to a dev and they said it is...

Chuck Hottle (1/5/2012)

---

We found that the session was executing "set implicit_transactions on" at several points and then erroring out for whatever reason. The session was then sleeping, but...

Thanks Craig, that is also good to know.

Thanks for the reply Gail. That is what I was afraid of, I've been using Paul Randal's long running transaction script and Mechanic's sp_whoisactive to get the last...

Thanks for the link, that is what I was looking for (I can't believe I missed that, I was just on thier site yesterday). And that is the answer...

That is what I thought, but I wanted to get a second opinion, thanks for the response!

Hello,

When adding\increasing the sesstimeout reg key, do you require a reboot for the change to take effect?