HOW TO
Find the session log file tables in tempdb of a SQL Server DBMS
Summary
Instructions provided describe how to view the session log file tables in the temporary database (tempdb) of a SQL Server DBMS.
Procedure
The recommended log file configuration for ArcSDE for SQL Server is session-based log file tables created in tempdb. To find the names of the log file tables, execute a query in tempdb to return a list of the tables located there.Execute the following query from a query window in the Query Analyzer or Management Studio:
Code:
USE tempdb
SELECT * FROM information_schema.tables
The returned list of tables includes table names, their types, and the names of the schemas in which the tables reside. The session-based log file table names will follow this format in ArcSDE 9 through 9.3.1: ##SDE_session<sde_id>. In ArcSDE 10.x, the format is ##SDE_session<sde_id>_<database_id>.
Note:
Temporary objects do not show up in Enterprise Manager or the Object Explorer in Management Studio; therefore, the query shown above must be executed to see these tables.
Article ID: 000008284
Software:
- ArcGIS Server
Receive notifications and find solutions for new or common issues
Get summarized answers and video solutions from our new AI chatbot.
Discover more on this topic
Search for related information
Find training related to this topic
Explore ideas and give feedback
Get help from ArcGIS experts
Download the Esri Support App