quote:

---

Supplying the password in sp_change_users_login is new with SP3. I guess to be completely up to date they should have included that.

---

Ahh... now that makes sense. Looking at an old test server I see that the SP3 changes are not there. Doesn't pay to keep things current I guess.

I agree the Update_One option is a much better choice. The SP3 BOL states that the Auto_Fix option may not get the login to user link right, and the pre-SP3 BOL states that the Auto_Fix option may grant more permissions than were previously allowed. Not good...

At least I learn something every time I visit this site. Keep up the excellent work! A little 'discussion' is healthy for all of us!

--Tom