Mombu the Microsoft Forum sponsored links

Go Back   Mombu the Microsoft Forum > Microsoft > sp_revokedbaccess
User Name
Password
REGISTER NOW! Mark Forums Read

sponsored links


Reply
 
1 24th June 16:16
lisa
External User
 
Posts: 1
Default sp_revokedbaccess


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 ****yzer 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.
  Reply With Quote


  sponsored links


Reply


Thread Tools
Display Modes




Copyright 2006 SmartyDevil.com - Dies Mies Jeschet Boenedoesef Douvema Enitemaus -
666