• on 2K8:

    xp_ReadErrorLog 0, 1, 'listening'

    -- Parameters defined:

    -- Parameter 1 (int), is the number of the log file you want to read, default is "0" for current log.

    -- Parameter 2 (int), value of 1 reads SQL error logs, value of 2 reads SQL Server Agent logs, with a default value of 1.

    -- Parameter 3 varchar (255), is a search string for the log entry, with a default value of NULL.

    -- Parameter 4 varchar (255), is another search string for the log entry, with a default value of NULL