I restored a db on my SQL 2000 server called R1. I went to add R1 to the user mapping of a user called JUNO. I get an error:
User or role 'JUNO' already exists in the current database.
So I ran on R1 as SA I ran:
DROP USER JUNO
Incorrect syntax near the keyword 'USER'.
So I tried:
EXEC dbo.sp_revokedbaccess N'JUNO'
Msg 15183, Level 16, State 1, Procedure sp_MScheck_uid_owns_anything, Line 17 The user owns objects in the database and cannot be dropped. Msg 15284, Level 16, State 1, Procedure sp_MScheck_uid_owns_anything, Line 34 The user has granted or revoked privileges to the following in the database and cannot be dropped.
My goal is not to drop JUNO... but to allow JUNO to access the db. Using a different user name is not an option.