sa_get_server_messages( first_line )

This procedure takes an INTEGER parameter that specifies the starting line number to display, and returns a row for that line and for all subsequent lines. If the starting line is negative, the result set starts at the first available line. The result set includes the line number, message text, and message time.

None

None

The following example uses the sa_get_server_messages system procedure to return a result set containing the content of the database server messages window, starting from line 16.

CALL sa_get_server_messages( 16 );