• If userabc has just restored the database, then it's going to be the database owner (dbo), so you shouldn't need to run sp_change_users_login. Unless I've missed something, that is. On a more general note, you should use ALTER USER instead of the stored procedure, which is deprecated.

    John