SQL Server Only: Setting PERMISSION_CACHE_THRESHOLD in DBTUNE can cause client connection attempt to fail when many objects exist in an ArcSDE instance. Error: "Microsoft OLE DB Provider for SQL Server: Timeout expired"
Last Published: August 25, 2014No Product Found
Bug ID Number
NIM039793
Submitted
October 31, 2008
Last Modified
June 5, 2024
Applies to
No Product Found
Version found
10.0
Version Fixed
N/A
Status
Fixed
The bug has been fixed. See the Version Fixed and Additional Information, if applicable, for more information.
Workaround
For SQL Server 2005 and above: Set the DBTUNE parameter PERMISSION_CACHE_THRESHOLD to -1. There is no work-around for SQL Server 2000.