SET PRO_CONNECT LOG

Controls logging for the current SQL Server connection.

Syntax

SET PRO_CONNECT LOG [ ON | OFF ][ WITH ({ STATEMENT, QUERY_PLAN })];

Parameters

Indicates that logging is turned on.

OFF

Indicates that logging is turned off.

STATEMENT

Indicates that statement tracing information is written to the log file.

QUERY_PLAN

Indicates that query plan information is written to the log file.

Notes

When logging is set ON, the current SQL connection begins logging to a file named as SQL_server_<server-id>_<ddmmmyyyy>_<hhmmss>.log.

For example: SQL_server_1_05MAY2005_112609.log

The server-id corresponds to the server ID shown in database_name.lg.

Logging files are created in the location from where you execute the proserve command.

The maximum size of each logging file is 500 MB. When SQL_server_<server-id>_<ddmmmyyyy>_<hhmmss>.log reaches 500 MB, the server logs a message indicating the file was closed due to reaching the maximum size. After this message is written, all logging stops, logging is set to the OFF state, and SQL_server_<server-id>_<ddmmmyyyy>_<hhmmss>.log automatically closes.

When logging commences to a new file, the file contents begin with information about the SQL Server environment, including:

Environment variable settings

Parameter values passed to the server at startup

Logging control values (such as size limits)

The SQL Server process ID

Each section of information written to the log file begins with the string

DDMMMYYYY HH:MM:SS < user-id >: For example, 19AUG2005 12:00:00 1: