Im having a bit of an issue with my SQL server what I am trying to do is map a user to the dbo default schema within MSSQL 2008. If I tick map and select the database then edit the default schema to dbo I get An exception occurred while executing a Transact-SQL statement or batch. User, Group or role ‘user’ already exists in the current database.
Which is true the user does but I want to map it to that schema?
Fixed this, just incase anyone has an issue where by you try and add users to a dbo mapping and it says the user already exists – the chances are you have restored the DB and the user SIDS have gone a bit wonky. What I did was re create the user account and all was fine.