Is This Content Helpful?
We're glad to know this article was helpful.
After upgrading to Microsoft SQL Server 2005, the time it takes to open an ArcSDE connection in ArcCatalog or ArcMap is very slow.
In SQL Server 2000, ArcSDE queries the sysprotects system table to get permission when building the ArcCatalog Table of Contents or any similar operation that generates a list of available datasets.
In SQL Server 2005, many of the system tables, such as sysprotects, have been deprecated in favor of system views. The tables still exist and can be queried, but the performance of the queries may be compromised.
A new query has been written to generate a list of datasets. This new query takes advantage of new SQL Server 2005 Transact-SQL operators and functions that improves connection performance.
Follow the steps below:
exec sp_dbcmptlevel 'database_name', 90