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 |
|
samamun001
Starting Member
17 Posts |
 Posted - 2004-10-14 : 02:09:18
|
| suppose i have1. select * from Bonus with(ROWLOCK) where BonusID = 22. select * from Bonus where BonusID = 2now i don't want to run the second select operation while my first select operation with rowlock is running samamun |
|
|
hgorijal
Constraint Violating Yak Guru
277 Posts |
Posted - 2004-10-14 : 02:27:40
|
| Row level locking is by default from SQL7. SQL server determines when to escalate ito page or table level locks.For more info on locking architecture, look in BOL Index under "Locking" What kind of information are you exactly looking for ?Hemanth GorijalaBI Architect / DBA...Exchange a Dollar, we still have ONE each.Exchange an Idea, we have TWO each. |
 |
|
|
sify
Starting Member
18 Posts |
Posted - 2004-10-14 : 02:50:13
|
| Help on Row Lock - Abstract question?Are you referring to Isolation Levels...? |
|
|
|
|
|
|
Rowlock