• Just an addendum to my article - for the

    "INSERT #Errors EXEC xp_readerrorlog", this extended proc is in the master database... So change it to:

    INSERT #Errors EXEC master..xp_readerrorlog

    Also - remember to drop the temp table.

    DROP TABLE #Errors

    Thanks!