Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
scase
Starting Member
4 Posts |
 Posted - 2007-04-04 : 10:43:01
|
| Forgive me if I cannot explain this correctly.I did a backup of a database on a SQL Server 2000 box. I then restored that database on a different SQL Server 2000 box.There were 2 users mapped (besides the dbo) on this database. These accounts are creating problems. I assume they are orphaned users.I was able to drop one user by issuing the EXEC sp_dropuser 'SOMEUSER' command.The other user I cannot seem to get rid of because it is marked as the owner of the database (along with dbo).How can I remove this user account as the owner of this database and then remove them? I really need to get this database moved to the new server.Any help would be GREATLY appreciated. I am really STUCK here.Sincerely,Shan2005 Ride for the Roses |
|
|
scase
Starting Member
4 Posts |
Posted - 2007-04-04 : 11:07:56
|
| I fixed the issue. There was one table still owned by the offending user. I made a copy of that table, deleted the old table and then re-created the original table. Problem solved.After this I was able to delete the user.2005 Ride for the Roses |
 |
|
|
|
|
|
Orphaned User?