rock path facing away
It was beautiful, my favourite day in Vanuatu
holidays 112.jpg
HPIM1001.JPG
Last photo from the first night.
Sylvia and Luke in the shower
IMG_9537.JPG
pretty magnificant view

 

September 2006
M T W T F S S
« Aug   Oct »
 123
45678910
11121314151617
18192021222324
25262728293031

The proposed new database owner is already a user in the database.

Enterprise manager icon
This is an error to do with a syncing issue as described here

Sp_changedbowner will return message 'the proposed new database owner is already a user in the database' if the sysdatabases/sysusers mapping is out of sync and the sysusers dbo SID is already mapped to the login. All you need to do is execute sp_changedbowner twice, once to change ownership to a different login and again to change it to the desired user.

The fix is described here

USE MyDatabase
EXEC sp_addlogin 'TempOwner'
EXEC sp_changedbowner 'TempOwner'
EXEC sp_changedbowner 'sa'
EXEC sp_droplogin 'TempOwner'

Popularity: 34% [?]

Everybody's a critic WTF?? Nothing about this made senseas useful as a blindfolded monkey throwing dartsmediocre ... at bestsolved my problem but needed modificationspectacular.  \'Nuff said (3 votes, average: 4.00 out of 5)
Loading ... Loading ...

Leave a Reply

 

 

 

You can use these HTML tags

<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>