BUG: RPC with Execute that Changes Database Causes Error 7222

ID: Q151597


The information in this article applies to:

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