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

ID: Q136390

The information in this article applies to:

Microsoft SQL Server version 6.0

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