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 |
|
vqd2697
Starting Member
2 Posts |
 Posted - 2009-04-27 : 10:31:19
|
| Hi all, We try to install one of softwares from EMC call Captiva and they said it requires the case-sensitive with row-level locking on database. I tried to install the new instance for SQL Server 2005 with case-sensitive but COULD NOT find any options with Row-level locking that they are asking for. Do anyone has any ideas where can I can find this option or set with ROW-LEVEL LOCING?Thanks,Vu |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2009-05-11 : 01:54:44
|
You can't. There is no such server setting.However there are query hints to tell sql server to try using row level locking, but even if you do, sql server may override it anyway if it finds table locking more efficient.
E 12°55'05.63"N 56°04'39.26" |
 |
|
|
|
|
|
Case-Sensitive with Row-Level locking