We found a SPID that had a lock on a table, and others that were blocking other SPIDs. We had all the users exit the application and restart their...

We're experiencing the 'disappearing data' issues this afternoon and we noticed numerous timeouts on our app server, where the middle-tier for the application is hosted. What could be causing...

so you're saying that timeout issues will cause rollbacks? But shouldn't we see some evidence of this somewhere is some log? We have seen timeout issues on our...

Yes, there are triggers on certain tables. We check all of our new stored procedure that have been put into production since the problem started, but we can't find...