• Another tip for xp_readerrorlog -- the first parameter is an integer that determines which error log to read.

    xp_readerrorlog      -- current errorlog

    xp_readerrorlog 1    -- most recent archived errorlog

    xp_readerrorlog 2    -- etc.

    Dave.