proc to order xp_enumerrorlog

create procedure sp_display_enumerrorlogs @size varchar(10) = 'nosize'
as
-- usage sp_display_enumerrorlogs  ['size']
-- this procedure has been tested on sql server 2000 sp4 and SQL Server 2005 sp2
-- any problems email pgr_consulting @ yahoo.com

create table #enumerrorlogs (archive_number int, archive_date datetime, file_size_bytes int)

insert #enumerrorlogs execute xp_enumerrorlogs

if @size = 'nosize'
begin

select * from #enumerrorlogs
order by archive_number
end
else
begin
select * from #enumerrorlogs
order by file_size_bytes desc
end
drop table #enumerrorlogs
go