Microsoft KB Archive/89935

{|
 * width="100%"|

The information in this article applies to:
 * Microsoft SQL Server version 4.2 for OS/2

BUG# 7373 (4.2)

SYMPTOMS
When a stored procedure has PRINT as the last statement in it, SQL Administrator does not output the results of the PRINT statement unless there is a GO command after the stored procedure call in the query window. For example, open a query window and create a stored procedure similar to the following:

create procedure test as  select count(*) from sysobjects Print &quot;Hello&quot; Now, open another query window and type: test The output is: 186 This is the result of the SELECT query. The output of the PRINT statement does not appear. Now, clear the query window and reexecute the stored proc by typing:

test This time the output is: Hello 186 The output of the PRINT statement during the previous execution of test appears now. However, executing the following test go will produce the following output, which is correct: 186  Hello

STATUS
Microsoft has confirmed this to be a problem in SQL Server version 4.2 for OS/2. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.
 * }

-

Last reviewed: April 28, 1997

© 1998 Microsoft Corporation. All rights reserved. Terms of Use.