Devart Forums

Is there anywhere that a comprehensive log or history of statements executed by the user or on behalf of the user is kept? Like for instance I want to see all of the queries I ran 2 days ago.

I have seen the SQL history and View > Output windows, but these only seem to store tab or session history.

Is there any way for me to turn on some kind of client-side logging for every statement?

Logging can be turned on as follows:

1. Select 'Tools -> Options' from the main menu. The 'Options' window opens.
2. Navigate to the 'Environment -> Output' branch.
3. Select the 'Write queries sent by the program to the SQL Log' and 'Log application errors' options.
4. Unselect the 'Delete application log after closing' option. Click 'OK'.
5. The *.log file can be found in the directory: Also, you can view logs on the 'SQL Log' tab of the 'Output' window that can be invoked by selecting 'View -> Output' from the main menu.