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

• Microsoft SQL Server version 6.0

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          : kbprg SSrvProg SSrvStProc kbbug6.00 
Version           : 6.0
Platform          : WINDOWS 
Issue type        : 

Last Reviewed: April 21, 1999