Kbase P11633: Record can not be found with EXCLUSIVE-LOCK when specific co
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
9/16/2003 |
|
Status: Verified
FACT(s) (Environment):
MS SQL
FACT(s) (Environment):
MS SQL DataServer
SYMPTOM(s):
Record can not be found when using EXCLUSIVE-LOCK
Record is found when using NO-LOCK
Within SQL Server, the following attributes under the CONNECTION tab are enabled
ANSI Warnings
ANSI Nulls
No Count
CAUSE:
The exact cause is unknown at the time of this writing
FIX:
1. Go to SQL Server Enterprise Manager console.
2. Expand the Microsoft SQL Servers tree.
3. Right click on the server name and select "Properties".
4. Select the "Connections" tab.
5. Under default connection options, you will see a list of attributes.
6. Disable the following attributes;
ANSI Warnings
ANSI Nulls
No Count