SQL Query to get SQL Error Logs

Go to SQL -> New Query and paste the following query it should return you the latest Error log

EXEC sp_readerrorlog

For more details and reference : 

http://www.lucasnotes.com/2012/10/querying-sql-server-error-log.html

 

http://sqlserverzest.com/2013/03/25/easy-way-to-search-the-sql-server-error-log/

 

http://sqlandme.com/2012/01/25/sql-server-reading-errorlog-with-xp_readerrorlog/