BUG: RPC w/ Execute That Changes Database Causes Error 7222

Q136390


The information in this article applies to:

BUG# NT: 11266 (6.00)

SYMPTOMS

You may encounter the following error when you attempt to execute a Remote Procedure Call:

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


CAUSE

If a stored procedure uses the EXECUTE statement to perform a Use Database statement, the above error is generated.

Statement example:


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


STATUS

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

Additional query words: sql6

Keywords : kbprogramming
Issue type : kbbug
Technology : kbSQLServSearch kbAudDeveloper kbSQLServ600


Last Reviewed: March 30, 2000
© 2001 Microsoft Corporation. All rights reserved. Terms of Use.