0

I am writing c# software which uses mssql2008r2 database. My software runs on many computers at same time. But sometimes mssql throws an error "new transaction is not allowed because there are other threads running in the session".

I believe that the transaction on one connection is not relevant to the other transactions on other connections. I don't need to know whether there are other active transactions on other connections to start a transaction, is that right?

Please give me an advice!

Regards, Orgil.D

Orgil
  • 187
  • 3
  • 13
  • `because there are other threads running in the session` makes me think maybe one query takes long and before its done, another one is fired. – Keyur PATEL Feb 09 '17 at 01:43
  • But if that query is on other connection, my connection doesn't care about that query, is that right? – Orgil Feb 09 '17 at 10:33

0 Answers0