Null login name for a database user
we have a software application called blackboard software working with sql server 2005.
After restore database, I realized the login is not created, then I use script created those logins.
In a database I found one of our user called bb_jreport have null login name, and null default databasename by using sp_helpuser bb_Jreport.
I cannot mapped to the login bb_jreport, for the button is grayed out.
How can I add the login name to the database user and update its default database name to the right databasename.
I tired to delete the user, and recreate, but it failed : cannot drop user because it owns a schema.
How can do with this, thanks
