Read SQL error log

In SQL Server Database, There is plenty of external storedprocedure is available.

To Read Error Log, we can use xp_readerrorlog, which is a external SP.

see the following code, it let us know, how to use this SP

This extended stored procedure will return a errorlog file.

EXEC master..xp_readerrorlog

SQL: ANY

This following Query Explain, how to use ANY in SQL Query.

USE pubs

GO

SELECT au_lname, au_fname

FROM authors WHERE city = ANY (SELECT city FROM publishers)

GO