Re: Database Users disappered after database restore

From: Tom Moreau (tom_at_dont.spam.me.cips.ca)
Date: 08/28/03 

Date: Thu, 28 Aug 2003 10:25:30 -0400

Check out sp_change_users_login in the BOL. 

-- 
Tom
---------------------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com/sql
"Oladimeji Suberu" <ladi.suberu@systemtech-ng.com> wrote in message news:063501c36d6e$c61d6070$a001280a@phx.gbl...
I am trying to restore a database from one machine to 
another.  I 've tried using Backup/Restore and equally 
using DTS.  I equally used db attach method of transact 
SQL.  
At the end of any of the operations, the database users 
are removed from the database leaving dbo only.
Has anybody experienced this?
Please help.
Oladimeji Suberu

Relevant Pages