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.
| Author |
Topic |
|
coolerbob
Aged Yak Warrior
841 Posts |
 Posted - 2008-04-17 : 10:50:37
|
| Are there any scenarios where an un-commited transaction would block further queries? |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2008-04-17 : 11:17:54
|
| Yes.Any updates done in that transaction will hold locks and prevent other connections from accessing the data.Or do you mean on the same spid? I've heard of some reports about that but it shouldn't happen.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
|
|
|
Transactions