BUG: RPC with Execute that Changes Database Causes Error 7222ID: Q151597
|
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'
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.
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