create table #t (dt datetime, process varchar(200), msg varchar(1000)) insert into #t exec sp_readerrorlog 0,1,'error' insert into #t exec sp_readerrorlog 1,1,'error' insert into #t exec sp_readerrorlog 2,1,'error' insert into #t exec sp_readerrorlog 3,1,'error' insert into #t exec sp_readerrorlog 4,1,'error' insert into #t exec sp_readerrorlog 5,1,'error' insert into #t exec sp_readerrorlog 6,1,'error' select * from #t where process <> 'logon'
Other References
How to use extended events to catch all errors in SQL Server
Pingback: Manufacturer information inside SQL server Himanshu Patel SQL Server Consultant developer & Administrator -
Pingback: Get TempDB files count Himanshu Patel SQL Server Consultant developer & Administrator -