Listing 1: Excerpt from the sp_ShowErrors Stored Procedure WHILE (@count < @logs) BEGIN IF (@count = 0) BEGIN INSERT INTO #errorlog values ('',' ',0) INSERT INTO #errorlog values ('',' ',0) INSERT INTO #errorlog values ('','****************',0) INSERT INTO #errorlog values ('','* LOG: CURRENT *',0) INSERT INTO #errorlog values ('','****************',0) INSERT INTO #errorlog values ('',' ',0) INSERT INTO #errorlog values ('',' ',0) END ELSE BEGIN INSERT INTO #errorlog values ('',' ',0) INSERT INTO #errorlog values ('',' ',0) INSERT INTO #errorlog values ('',' ',0) INSERT INTO #errorlog values ('',' ',0) INSERT INTO #errorlog values ('','********************',0) SELECT @output = '* LOG: CURRENT - ' + convert(varchar(3),@count) + ' *' INSERT INTO #errorlog values ('',@output,0) INSERT INTO #errorlog values ('','********************',0) INSERT INTO #errorlog values ('',' ',0) INSERT INTO #errorlog values ('',' ',0) END -- BEGIN CALLOUT A SELECT @SQL = 'exec master..sp_readerrorlog ' + convert(varchar(3),@count) -- END CALLOUT A INSERT INTO #errorlog (log_entry, continuationrow) EXECUTE (@SQL) SELECT @count = @count + 1 END