Re: sp_revokedbaccess

From: Dan Guzman (danguzman_at_nospam-earthlink.net)
Date: 12/31/03

  • Next message: Dan: "Logging changes to the data schema" 
    Date: Tue, 30 Dec 2003 19:14:25 -0600

    Can you post the sp_revokedbaccess code from your test server? AFAIK, no
    new required parameters to this proc were introduced by a service pack.
    This would break a lot of code. 

    -- 
Hope this helps.
Dan Guzman
SQL Server MVP
"Lisa" <LMZELAZNY_NOSPAM@AOL.COM> wrote in message
news:045d01c3cf39$92e061d0$a401280a@phx.gbl...
> 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.
  • Next message: Dan: "Logging changes to the data schema"

    Relevant Pages

    • Re: sshd known_hosts query
      ... which don't really match the required parameters. ... OK, I can recognise that the remote computer is identified by both name and IP, but both examples seem to have ignored one or more parameters. ... It stores keys for each server to which I connect and validates that it's the same one as last time (re-installing a server causes its keys to change, ...
      (uk.comp.os.linux)
    • RE: Can`t logoff from Server
      ... If you still want to restart or shut down the computer, ... When you see the message Please select the operating system to start, ... Microsoft Windows Server 2003 on the list that is displayed, ...
      (microsoft.public.windows.server.general)
    • Re: Help getting X working (Solaris 10 X86 u3 (under Virtual PC)
      ... Solaris 10 under VMWare Server 1.03. ... Load "Xst" ... Please refer to your Operating System Vendor support pages ...
      (comp.unix.solaris)
    • Re: Unauthorized use of Server 2003
      ... failure to patch the operating system and any network-active ... flatten the server immediately and scan any workstations that were ... I thought that flattening was pretty clear from ... The system needs a format install with a W2k3 SP1 integrated CD, ...
      (microsoft.public.security)
    • Re: Event Based or Get-Key based
      ... changing or responding to input) while the core server is off "talking to" ... A non-alpha implementation uses nonblocking operations ... obtaining a single keypress in from stdin. ... C delegates to operating system. ...
      (rec.games.roguelike.development)