Re: User Sync.
From: Carlos Eduardo Rojas (carloser@mindspring.com)
Date: 02/26/03
- Next message: Carlos Eduardo Rojas: "Re: Free SQL?"
- Previous message: Jamie Orzechowski: "SQL Server Listen on only 1 IP Address??"
- In reply to: Manoj: "User Sync."
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
From: "Carlos Eduardo Rojas" <carloser@mindspring.com> Date: Wed, 26 Feb 2003 15:16:36 -0500
Use the system stored procedure sp_change_users_login to change the
relationship between logins and users. There's more info about it in BOL
(books online).
-- Carlos E. Rojas SQL Server MVP Co-Author: SQL Server 2000 Programming by Example "Manoj" <mgmanoj@hotmail.com> wrote in message news:069a01c2ddce$00defb50$2f01280a@phx.gbl... > Hi > > I have restored the database from other server & now if i > try to create the user on new server & grant permission > it gives error, user exist in database. My problem is > user owns the objects so i can not delete from database. > How to sync. the user permissions. > > thanks for the help > > Manoj
- Next message: Carlos Eduardo Rojas: "Re: Free SQL?"
- Previous message: Jamie Orzechowski: "SQL Server Listen on only 1 IP Address??"
- In reply to: Manoj: "User Sync."
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
