Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 resources and uncommited transactions

Author  Topic 

nizmaylo
Constraint Violating Yak Guru

258 Posts

Posted - 2001-09-29 : 14:07:27
Lately we've noticed the following behavior of SQL Server.
If a user issues a BEGIN TRAN statement in a query analyzer, then executes the statement WITHOUT issuing a COMMIT TRAN statement, it could almost freeze the entire server.
What's the problem? It's just one uncommitted transaction.


helena
   

- Advertisement -