BUG: Failed SQL Server RPC Call Results in Batch Termination

ID: Q165132

The information in this article applies to:

Microsoft SQL Server version 6.5

BUG#: 16506 (6.5)

SYMPTOMS

The failed execution of a SQL Server RPC call terminates the current batch, but reports it as an informational message to the client.

STATUS

Microsoft has confirmed this to be a problem in Microsoft SQL Server version 6.5. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.

MORE INFORMATION

For example, if you try to run "exec RemServer.master.dbo.sp_who" and the SQL Server is not started on the RemServer, the connection returns:

Msg 18481, Level 9, State 2
Unable to connect to site 'RemServer' because it is unavailable or does
not exist.

The batch is immediately terminated, so a check for @@ERROR will not even be run.

In this situation, the client receives an informational message. The DB-Library call dbsqlexec returns SUCCEED, and an ODBC SQLExecDirect reports SUCCESS_WITH_INFO.


Keywords          : kbusage SSrvGen 
Version           : 6.5
Platform          : WINDOWS 
Issue type        : kbbug

Last Reviewed: April 9, 1999