• There is an easier way to do this. Just use xp_enumerrorlogs.

    See my blog post on the subject: Error Logs: Part Two

    Also see Error Logs: Part I which also shows you how to do it in SQL 2000.


    My blog: SQL Soldier[/url]
    SQL Server Best Practices:
    SQL Server Best Practices
    Twitter: @SQLSoldier
    My book: Pro SQL Server 2008 Mirroring[/url]
    Microsoft Certified Master: SQL Server, Data Platform MVP
    Database Engineer at BlueMountain Capital Management[/url]