Re: remove user

From: Steve Thompson (SteveThompson@nomail.please)
Date: 02/19/03 

From: "Steve Thompson" <SteveThompson@nomail.please>
Date: Wed, 19 Feb 2003 11:28:43 -0500

"Mitch" <zach4mich@hotmail.com> wrote in message
news:041501c2d831$8f394f10$2f01280a@phx.gbl...
> I attach or restore database to another sql instance on
> another machine. sql accounts attached do not agree with
> the same account already existing on new server. how do
> I remove the accounts attached to the restored database.
> I know there has to be a sp procedure somewhere.

This should help you:
PRB: "Troubleshooting Orphaned Users" Topic in Books Online is Incomplete
http://support.microsoft.com/default.aspx?scid=kb;en-us;274188

Steve

Relevant Pages

  • Re: remove user
    ... Thanks Steve, that's exactly what I was looking for ... >> I attach or restore database to another sql instance on ... >> I remove the accounts attached to the restored ...
    (microsoft.public.sqlserver.security)
  • remove user
    ... I attach or restore database to another sql instance on ... the same account already existing on new server. ... I remove the accounts attached to the restored database. ...
    (microsoft.public.sqlserver.security)
  • Re: Log Shipping
    ... Select and Update permissions on the msdb.dbo.log_shipping_primaries ... the above table is updated by the backup log job on the primary server in ... >> primary SQL instance and my secondary SQL instance to sysadmins on my ... >> secondary service accounts are pretty secure. ...
    (microsoft.public.sqlserver.server)