I have a database in SQL server 2000 I want to migrate this database to SQL server 2005. I have created the database login in SQL server 2005 that the user in DB SQL 2000 uses. I then want to be sure if the user has the DB_OWNER role on the database. I can check this using the SP_HELPLOGINS sotored procudure, if there is not a entry for my loginname on the restored sql2005 db and a memeberOf the db_owner role, how do I create that user or update it so it does have db_owner access. I can do this through the studio but dont know the SQL syntax for it.