Competition: What’s your favorite Redgate tool? Enter now.

How to modify User under the database after restore

tomchutomchu Posts: 7
edited July 12, 2006 9:03PM in SQL Backup Previous Versions
When the database restored, the entire users in the database has restore under the database. (but not on the server)
I can not login to the database using the same user name and password.
There is no option in Enterprise Manager I can change the user login names and password. (Under the database)
Then I try to delete it and the error said the user own an object and I can not delete.

I just need to get access using the same user name.

Please help

Comments

Sign In or Register to comment.