How to modify User under the database after restore
tomchu
Posts: 7
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
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
http://msdn2.microsoft.com/en-us/library/ms175475.aspx
http://support.microsoft.com/default.aspx?scid=kb;en-us;246133
http://support.microsoft.com/kb/918992/
SQL Backup Consultant Developer
Associate, Yohz Software
Beyond compression - SQL Backup goodies under the hood, updated for version 8