BUG: Query Analyzer May Not Display All Results with Some Error Sequences (258234)

MORE INFORMATION

The following script uses RAISERROR and demonstrates the problem. The 'Missing Output' result set in the second trigger is not displayed in the Query Analyzer output.

select @@VERSION 
go 

set implicit_transactions off 
if (@@trancount > 0) 
   rollback tran 
go 

use tempdb 
go

drop table tbl50000InsertInTrigger 
drop table tbl50000Insert 
go 

create table tbl50000InsertInTrigger (iID int NOT NULL) 
go 
create table tbl50000Insert (iID int NOT NULL) 
go 

create trigger trg50000Insert on tbl50000Insert for INSERT 
as 
begin 
  select 'Inserted1', * from inserted select 'First command in trigger', "@@ERROR" = @@ERROR, "@@TRANCOUNT" = @@TRANCOUNT 

  rollback tran 
  insert into tbl50000InsertInTrigger values(9999) 
  raiserror('This is bad', 14,1) 
end 
go 

create trigger trg50000Insert2 on tbl50000Insert for INSERT 
as 
begin 
    -- -- -- Query Analyzer fails to display the following result -- 
   select @@ERROR as 'Missing Output' select 'Command in trigger 2', @@TRANCOUNT, @@ERROR 
end 
go 

set implicit_transactions on 
go 
insert into tbl50000Insert values(100000) rollback tran 
go