BUG: RPC with Execute that Changes Database Causes Error 7222

 Last reviewed: April 16, 1997
Article 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 kbbug6.00
Version : 6.00
Platform : WINDOWS

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: April 16, 1997
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.