Broken connection timeout

From: "geza" <mezga_geza@xxxxxxxxxxx>
Date: 16 Jan 2007 10:11:39 -0800

I did following test:
1. Connected to SQL Server 2000 from a client machine using asp.net
2. Started transaction
3. Locked a table
4. Run Thread.Sleep causing the asp.net page to hang
5. Physically disconnected the client machine from network while it was
still in the transaction

After this, the table remains locked. After 5 minutes, while the client
was still offline, the transaction rolled back itself and the lock did
release. The questions are:
1. What caused the rollback.
2. How can i set the time after this should happen.

.

Prev by Date: Re: SA Password Change
Next by Date: Rather urgent: Cannot open user default database. Login failed.
Previous by thread: SA Password Change
Next by thread: Rather urgent: Cannot open user default database. Login failed.
Index(es):
- Date
- Thread

Relevant Pages

Re: Transaction Isolation Level
... This means that while I initiate a transaction selecting all new orders it ... My query is executed on a SQL server 2005. ... the isolation level you should use is snapshot isolation. ...
(comp.databases.ms-sqlserver)
Re: Windows Completely Locks Up!! FREEZE
... failing to start/run the Distributed Transaction Coordinator. ... Error Specifics: ... The Business Contact Manager SQL Server Startup Service service terminated ... The service did not respond to the start or control request in a timely ...
(microsoft.public.windowsxp.general)
Re: Asynchronous Stored Procedure Never Returns - Help?
... If you have the Sql Server 2000 or 2005 docs they are thorough and can be ... for Transaction SQL Reference from the drop-down or select a keyword from ... your query in Query Analyzer or Sql Server Management Studio, ...
(microsoft.public.dotnet.languages.csharp)
RE: Qry Analyzer Debug broken: XP SP2
... The reason for Error 508 and Error code 0x80070005 is ... How to configure Windows XP Service Pack 2 for use with SQL Server ... The error code 0x800706ba translates to "RPC server ... unchecked on the client machine, this is a default setting that is checked. ...
(microsoft.public.sqlserver.server)
Re: Replication solution?
... Replication is your solution for distributed transaction processing...but ... some cases replication makes changes to the schema. ... identical SQL Server in the Ottawa would make it faster for the Ottawa ... I don't think log shipping would do us any good since we need two active ...
(microsoft.public.sqlserver.replication)