Re: "Drop User" statement does not seem to work

Check out sp_change_users_login in the BOL.

--
Tom

----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
..
"Andrew" <Andrew@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:FF46C63C-56E8-41F7-B238-2E0DA602E209@xxxxxxxxxxxxxxxx
I restored a copy of the production database onto the staging db server.
Some
of the production database users which need to be removed did not seem to
work when I issued "drop user [username]" statement. I also tried
"sp_dropuser [username]" and that did not work either. Has anyone
encountered
this issue? Thanks.

.

Relevant Pages

  • Re: Update Performance
    ... All other replies may be ignored:) ... >>> SQL Server MVP ... >>>> Add a row to tblStats with the count from the staging table. ... >>>>> should alleviate any single threading issues you are seeing. ...
    (microsoft.public.sqlserver.programming)
  • Re: "disallowed construct" on indexed view
    ... Please see the examples in the "Creating Indexed Views" topic in BOL. ... The SUM() point is valid, and without seeing the DDL we can't know whether ... "Jacco Schalkwijk" wrote ... > SQL Server MVP ...
    (microsoft.public.sqlserver.programming)
  • RE: Indexes, primary keys constraint type from sysconstraints -table?
    ... together with OBJECTPROPERTY and ... COLUMNPROPERTY ... Look those up in BOL. ... Mike Epprecht, Microsoft SQL Server MVP ...
    (microsoft.public.sqlserver.clients)
  • Re: INSERT Problem
    ... Allan Mitchell MCSE,MCDBA, ... > INSERT Staging VALUES ... > Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) ...
    (microsoft.public.sqlserver.dts)
  • Re: subtotal on a matrix
    ... Look up the topic ROLLUP Operator in BOL. ... SQL Server MVP ... "offa via SQLMonster.com" wrote in message ... > i have this matrix report that looks like that: ...
    (microsoft.public.sqlserver.server)