Navigation:  Advantage SQL > System Procedures > Procedures >


Advantage SQL Engine

Previous pageReturn to chapter overviewNext page

Retrieves the contents of the active query logging table.



 EncryptionPassword, Character, 255 )


EncryptionPassword (I)

On free connections, the password to use if the log table is encrypted.



ID (O)

Unique identifier for the query.

Start Time (O)

Time and date that the query was began.

Optimized (O)

True if the query is properly optimized.

Return Code (O)

Return Value of the query.

Rows Affected (O)

Number of rows affected by the query.

End Time (O)

Time and date that the query was ended.

Run Time (O)

Elapsed time the query was processed by the server in milliseconds.

Database (O)

Name of the database the user is connected to.

User Name (O)

User name for data dictionary connections.

Connection Name (O)

Connection name.

Application ID (O)

Application ID of the application executing the query.

Query (O)

The query that was executed.


sp_getQueryLoggingResults can be used to retrieve the contents of the Query Logging output table while query logging is currently active.  While the results can be retrieved either by directly opening the table or using an SQL statement, this procedure is useful if Query Logging is currently enabled to retrieve the results of the active query log.  To retrieve logging information on a data dictionary, the user must be logged in as the administrative user, ADSSYS or be a member of the DB:Admin group.


EXECUTE PROCEDURE sp_GetQueryLoggingResults( null );

See Also