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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-02-13 : 07:38:16
|
| Naz writes "Hello,Hope you guys can help me. I have implemented row locking by using the row locking hint "with (rowlock)" or "with (holdlock, rowlock)" but this locks the whole table instead.Is there actual row locking in SQL Server?Naz" |
|
|
ValterBorges
Master Smack Fu Yak Hacker
1429 Posts |
Posted - 2003-02-13 : 09:00:02
|
| ROWLOCK is supposed to be a row-level lock.How are you handling your transactions.Can you post your stored procedure.Depending on what your trying to achieve UPDLOCK mightalso work for you if you want to place write lock but allow other users to read. |
 |
|
|
|
|
|
row locking is locking at table level