You are here:Home » tsql » Read current error log for SQL Server error log

Read current error log for SQL Server error log

create table #readerrorlog (LogDate datetime,ProcessInfo varchar(100),TextData varchar(max))
insert into #readerrorlog exec sp_readerrorlog

select * from #readerrorlog

drop table #readerrorlog