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 |
erikkl2000
15 Posts |
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2006-08-06 : 16:42:59
|
You are trying to drop dbo?==========================================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. |
|
|
erikkl2000
15 Posts |
Posted - 2006-08-06 : 16:49:53
|
Yes |
|
|
erikkl2000
15 Posts |
Posted - 2006-08-06 : 16:57:01
|
That error accrues when i try to remove a user mapping... |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2006-08-06 : 18:21:15
|
You can't drop dbo - it is the databae owmner.==========================================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. |
|
|
erikkl2000
15 Posts |
Posted - 2006-08-06 : 20:32:13
|
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?erik |
|
|
erikkl2000
15 Posts |
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2006-08-06 : 21:55:41
|
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. |
|
|
|
|
|