Read SQL Server Logs with TSQL

create procedure sp_readerrors
as

declare @string1 nvarchar(64) = null; 
declare @string2 nvarchar(64) = null; 
declare @logNum int = 0; 
declare @logtype int = 1;
declare @NumErrorLogs int;

begin
 
drop table if exists #Errorlog;

create table #ErrorLog 
( 
LogDate datetime, 
ProcessInfo nvarchar(16), 
Text nvarchar(2048) 
) ;   
    
--count the number of error logs from the registry 
EXEC master.dbo.xp_instance_regread N'HKEY_LOCAL_MACHINE', N'Software\Microsoft\MSSQLServer\MSSQLServer', N'NumErrorLogs', @NumErrorLogs OUTPUT;
select @NumErrorLogs;

while (@logNum < @NumErrorLogs) 
 begin 
insert into #Errorlog 
exec xp_readerrorlog @logNum, @logtype, @string1, @string2 
set @logNum = (@logNum + 1); 
 end

end

--read the data out
--select * from #ErrorLog