set nocount on 
go

if exists (select * from dbo.sysobjects where id = object_id('dbo.tErrorLogs') 
		and OBJECTPROPERTY(id, 'IsUserTable') = 1)
drop table dbo.tErrorLogs
GO

CREATE TABLE dbo.tErrorLogs (
	RowNumber int IDENTITY (1, 1) NOT NULL ,
	ErrorText varchar (6000) NULL ,
	continuationrow bit NULL 
) 
GO

ALTER TABLE dbo.tErrorLogs ADD 
	CONSTRAINT PK_tErrorLogs PRIMARY KEY  NONCLUSTERED 
	(
		RowNumber
	)  
GO

declare @path varchar(2000)
declare @filename varchar(2000)

set @path = 'Q:\Program Files\Microsoft SQL Server\MSSQL$XXX\log\ERRORLOG'

insert into tErrorLogs
exec sp_readerrorlog 1, @path

set @filename = @path + '.1'
insert into tErrorLogs
exec sp_readerrorlog 1, @filename

set @filename = @path + '.2'
insert into tErrorLogs
exec sp_readerrorlog 1, @filename

set @filename = @path + '.3'
insert into tErrorLogs
exec sp_readerrorlog 1, @filename

set @filename = @path + '.4'
insert into tErrorLogs
exec sp_readerrorlog 1, @filename

set @filename = @path + '.5'
insert into tErrorLogs
exec sp_readerrorlog 1, @filename

set @filename = @path + '.6'
insert into tErrorLogs
exec sp_readerrorlog 1, @filename

set @filename = @path + '.7'
insert into tErrorLogs
exec sp_readerrorlog 1, @filename

set @filename = @path + '.8'
insert into tErrorLogs
exec sp_readerrorlog 1, @filename

declare @errortext varchar(3000)
declare @rownumber int

DECLARE error_cursor CURSOR FOR
SELECT errortext, rownumber FROM tErrorLogs
WHERE continuationrow = 1
ORDER BY RowNumber

OPEN error_cursor

FETCH NEXT FROM error_cursor
INTO @errortext, @rownumber

WHILE @@FETCH_STATUS = 0
BEGIN
		update tErrorLogs set errortext = errortext + @errortext
		where rownumber = @rownumber - 1
   		FETCH NEXT FROM error_cursor
   		INTO @errortext, @rownumber
END

CLOSE error_cursor
DEALLOCATE error_cursor

delete tErrorLogs WHERE continuationrow = 1 
go

alter table tErrorLogs add DateAdded datetime NULL 
go
alter table tErrorLogs drop column continuationrow 
go

update tErrorLogs 
set dateadded = left(errortext, 22)
from tErrorLogs
where isdate(left(errortext, 22)) = 1
go

CREATE CLUSTERED INDEX IX_tErrorLogs ON dbo.tErrorLogs
	(
	DateAdded
	) 
GO