I know this is an easy one but i have just resently started really paying attention to things like users and roles..
When i right click on a user at server level i get the propertys for that user. Now i try to remove the user mapping from a table and i get this error.. So what i have done is create a database under this username and now i can not remove the mappings from this user for that reason?
what i have done is create a database under this username and now i can not remove the mappings from this user for that reason?
I suspect that is the case. The user will be the database owner. You will need to make someone else the database owner (sp_changedbowner) then maybe you can remove the user. Bit surprised you get that error for this though.
If that doesn't fix it look at master..syslogins and db..sysusers to check the sid mappings.
========================================== Cursors are useful if you don't know sql. DTS can be used in a similar way. Beer is not cold and it isn't fizzy.