• Password, it should be unique to each user name.

    The password is stored as nvarchar(10) it's text.

    I thought the SP, what do you think?

    Relatively low amount of changes but I need to allow this user, I have no amount of users so you can ignore the volume table or the number of users that is under construction right now.