Lisa 2010-06-24 16:16:40
I’ve got 2 servers running sql server 2000 enterprise
edition. The prod server has operating system windows nt
5.0 (2195) and product version 8.00.534 (SP2). The test
server has the same operating system and product version
8.00.760 (SP3). When I run the sp_revokedbaccess
procedure in the test system, I get the following error
message: Procedure sp_revokedbaccess expect parameter
@error which was not supplied. – regardless if I run using
query analyzer or try to delete the user in the database
directly. This procedure works fine on the prod server.
When I compare the code for sp_revokedbaccess from the
test to prod server, the code is obviously different but I
have been unable to find any references to bugs/fixes from
microsoft, including the latest SP3A release, for the
sp_revokedbaccess procedure. Has anyone else experienced
this problem or do I need to contact microsoft directly?
Remove the “_NOSPAM” from sender’s email address when
replying via email.