Microsoft SQL Server database administrators have many excellent logging and debugging tools available to them. Among these is the “default trace.” The SQL Server database engine ships with a special trace enabled and logging *.trc or “trace” files to the default SQL LOG folder (database system log messages, *not* transaction logs). These traces can be viewed with the SQL Server Profiler tool included with the standard SQL Management tools install option. Find more details in the following related articles:
- default trace in SQL Server (simple-talk.com)
- default trace enabled Server Configuration Option (technet.microsoft.com)
If more detailed trace information is needed, the SQL Profiler provides the ability to select specific trace criteria beyond what the default trace provides. See the official Microsoft documentation or search the web for more on SQL Server tracing and profiling features.