• Very cool, I definitely need to implement this. I have two servers that go through a ridiculous amount of logins every day, so this will be good to help monitor them more effectively.

    I've also taken to forcing the error log to cycle every two weeks, syncing with our pay period. At 11:59pm Sunday night, I have a scheduled job that runs a sp_cycle_errorlog to keep the logs a bit more tidy.

    Thanks!

    -----
    [font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font]