We have a Windows application connecting to the WEbservices tier and then to DB tier for getting the data. Earlier this was developed and maintained in earlier .NET framework version. This use to work in .NET 3.5 framework. Recently we had migrated the solution
and code to VS 2010 and .NET 4.0 Framework.
After it went live, the transactions in the DB are not getting committed and are getting rollback after 5-15 minutes. The entry transactions which we entered from the UI are getting deleted as part of Transaction rollback. When we had checked the DB, there
are some open transactions in SYSPROCESSES table in MASTER DB.
Could any one suggest the solution for this? Is this specific to .NET 4.0 or do we need to do any more changes in our Code?