Why Not Just Use the File System?
When possible I prefer to go into the file system and open the SQL Server error logs in a text editor e.g. Notepad++ or UltraEdit. However, there are sometimes you may have access to a SQL Server instance but not be able to RDP or otherwise scan the file system.
That’s where this comes in – straight T-SQL.
Click through for demos.