Submitted by: Hannes du Preez(ojdupreez1978@gmail.com)

Language: SQL, Expertise: Intermediate: Learn an easy way to find where your error logs are being stored.

It is quite easy to find the error log location through a quick query:

SELECT SERVERPROPERTY('ErrorLogFileName') AS 'Error log file location'  

This shows where your Error log file is stored.