Is This Content Helpful?
We're glad to know this article was helpful.
Instructions provided describe how to view the session log file tables in the temporary database (tempdb) of a SQL Server DBMS.
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:
SELECT * FROM information_schema.tables
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.