_IV_RECENT_LOG System Query
The system query _iv_recent_log returns the records that were recently appended to the 602SQL Server defined logs. Each record in the query corresponds to one log entry.
Column description
| Log_name |
CHAR |
Name of the log this entry originates from (empty for the basic log) |
| Seq_num |
INT |
The ordinal number of the log entry |
| Log_message |
CLOB |
Text of the entry |
| Log_message_w |
NCLOB |
Text of the entry in UNICODE |
All users may query the basic log as follows:
SELECT * FROM _iv_recent_log WHERE Log_name=''
Only a configuration administrator (see 602SQL Server administration) may execute queries on other logs.
The amount of information the query is able to return is set by the TraceLogCacheSize server property.
