Kay Smoljak wrote: > Actually, I logged in with my Windows user and tried it anyway... and got:
i guess you're in the admin group on that server. i wouldn't have expected that. > Server: Msg 15110, Level 16, State 1, Procedure sp_changedbowner, Line 47 > The proposed new database owner is already a user in the database. but isn't recognized as existing db owner. > If I delete the user first, the site will stop working completely and > all hell will break loose, no? does it work now? do you have backups? if you do, take the db off-line & drop the user from the db (not from the logins) then try again. i've tried to recreate this but no matter what i do as long as that user either created the object or was DBO it can access the objects unqualified (connecting using that user name in query analyzer). ditto using a DSN for that user/password. you might have more luck on the sql server list/ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:232853 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
