SQL 2000 Add new user in restored database.
Posted on 2011-05-09
Last week I restored a database in a new server. Now, the network user (administrator) that I use to connect to the database doesn't have the login information. I delete it, but when try to add it again, it says that already exist. I don't want to delete it from the security section, because is the owner of all tables. I try the Auto Fix command, but it gave me the following error: "Procedure or function sp_change_users_login has too many arguments specified." . I want to know if exist another way to give the loging back to this user.