>I'm not sure why you would have to drop the user. The purpose of sp_change_user_login is to map an orphaned database user to an existing login.
>
Thanks for your help - at least I can move forward now.
Anyone else have any book recommendations for learning about stored procs? Really prefer something with lots of examples and/or a reference to the system stored procedures. Did a search on Amazon and there were only a couple of choices and neither had good reviews.
Del
Del