Query for searching system log in SSMS

Question

Hi All,
As title, is there any way to query SQL system log not seeing it in log viewer?
The reason why I ask is I'd like to query the SQL system logs in SSMS including where clause or filters.

Thank you in advance.

Answer 1

Hi @중석 김 ,

from the official doucment, the description of the system log is a record of the events logged by the Windows operating system components.
https://learn.microsoft.com/en-us/sql/tools/configuration-manager/viewing-the-windows-application-log?view=sql-server-ver15

but you also want to including where clause or filters. The where clause is not included in the system log.

if you just want to query system log, you can just get from the log viewer.

if you want to see query history in ssms, you can refer to this issue:https://stackoverflow.com/questions/5299669/how-to-see-query-history-in-sql-server-management-studio
There is no way to see queries executed in SSMS by default

-------------

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

Unfortunately, there is no DMV to access the errorlog.

But you can run:

INSERT #tmp(...)
   EXEC xp_readerrorlog

And then run filtering in the temp table.

Answer 3

The SQL Server error log is simply a text file on the hard drive. It is much simpler to just open the file using a text application.

https://learn.microsoft.com/en-us/sql/tools/configuration-manager/viewing-the-sql-server-error-log?view=sql-server-ver15