>> Thru looking at the code and trial and error, I was able to get the following to seem to work by executing the following from the query analyzer (message said 1 orphaned user was fixed):
>
>sp_change_users_login 'UPDATE_ONE', 'closing', 'closing'
>>
Okay, what I figured out is I had to execute sp_dropuser 'closing' next. Then I could actually remove the login in SEM. At that point I could create a new 'closing' login (via SEM) and give access to the database. Seems pretty convoluted. Is this what you would have done, Mike?
I have Que's Using SQL Server 7.0, but it doesn't go into much detail on these kinds of things either. Do you have a book recommendation that gives me a little more detail on things like this? One thing that would be nice is a reference on all the sp's, what the parameters are, and when one would need to use them. Any thoughts along these lines?
Del
Del