Microsoft KB Archive/258234

= BUG: Query Analyzer May Not Display All Results with Some Error Sequences =

Article ID: 258234

Article Last Modified on 10/9/2003

-

APPLIES TO


 * Microsoft SQL Server 7.0 Standard Edition
 * Microsoft SQL Server 2000 Standard Edition

-



This article was previously published under Q258234



BUG #: 55649 (SQLBUG_70)

BUG #: 56441 (SQLBUG_70)



SYMPTOMS
Certain sequences of errors may cause missing results in Query Analyzer (Isqlw.exe). This is only a display issue; the actual commands execute correctly.



WORKAROUND
To work around this problem, use Osql.exe or another utility to run the same command sequence.



STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.



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

Keywords: kbbug kbpending KB258234

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.