BUG: RPC with Execute that Changes Database Causes Error 7222

ID: Q151597

The information in this article applies to:

Microsoft SQL Server version 6.0

BUG#: WINDOWS 11266 (6.00)

SYMPTOMS

The following error is encountered when you attempt to execute a Remote Procedure Call (RPC):

Error message 7222, Level 19, State 1
Received bad token 0xe3 from site '%s'

STATUS

Microsoft has confirmed this to be a problem in Microsoft SQL Server version 6.0. This problem does not occur in Microsoft SQL Server 6.5.

MORE INFORMATION

If a stored procedure utilizes the EXECUTE statement to perform a Use Database statement, the above error is generated. The following is an example of a statement that generates the error:


   create procedure spTest
   as
   begin
      execute('use pubs')
   end

Additional query words: 6.00


Keywords          : kberrmsg ssvrprog 
Version           : 6.00
Platform          : WINDOWS 
Issue type        :

Last Reviewed: March 26, 1999