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.
This is a known issue in 9.3.
This issue was fixed in ArcSDE 9.3.1. Either upgrade the geodatabase or use the default session-based log file configuration. The settings for this are as follows:
- 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.