With the Interactive SQL logging feature, you can record commands as you execute them. Interactive SQL continues to record until you stop the logging process, or until you end the current session. The recorded commands are stored in a log file.
Beginning to log Interactive SQL commands
Choose SQL | Start Logging.
In the Save dialog, specify a location and name for the log file.
Click Save when finished.
To stop logging Interactive SQL commands, select SQL | Stop Logging.
To start logging by typing in the SQL Statements
pane, enter and execute start logging “c:\file_name.sql”,
where c:\file_name.sql is
the path, name, and extension of the log file. A log file must have
the .sql extension.
Include the single quotation marks if the path contains embedded
spaces. To stop logging, enter and execute stop logging.
The commands start logging and stop
logging are not Transact-SQL commands,
and are not supported by Adaptive Server outside the Interactive SQL dialog box.
Once you start logging, all commands that you try to execute are logged, including ones that do not execute properly.
