Pools of session-based log file tables in SQL Server are not being used if the geodatabase is in the DBO schema

Description

If the default log file configuration of a DBO-schema geodatabase in SQL Server is modified to use pools of session-based log files, the pool of log file tables are not used, and new session-based log files are created in the individual user's schema.

Cause

This is a known issue in 9.3.

Workaround

• In SDE_dbtune, SESSION_TEMP_TABLE under the LOGFILE_DEFAULTS keyword is set to 0.
• The SDE_server_config parameter ALLOWSESSIONLOGFILE is set to TRUE.
• The SDE_server_config parameter LOGFILEPOOLSIZE is set to 0.