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 - 2001-06-19 : 10:29:17
|
Kutsal writes "Is there a way to turn on row-level locking by default for every statement in SQL 7 or 2K? Without using statements like SELECT * FROM tbl WITH ( ROWLOCK )?
I know SQL Server has an 'intelligent' locking mechanism that determines how to lock. But I need to know if there is a way to make sure it always does row-level locking and doesn't ever promote up to page or table-level locking.
Does anyone know how? Is there an option to turn on?
Thanks!
-K
SQL Server Versions: 7.0 (SP 4) and 2000
Windows Version: NT 4.0 (SP 4) and Windows 2000" |
|
|
|
|
|
Row locking in SQL Server 7+