Sp_changedbowner
Apr 24, 2001what is the proper command for using sp_changedbowner? what all do i need to specify? is it just sp_changedbowner @loginname?
View 2 Replies
ADVERTISEMENT
Sp_changedbowner
Jan 12, 2001Hi all,
How to change the database owner to 'sa' from 'ABC
eddy'
I tried to execute the following SP_CHANGEDBOWNER and got
the following error message..
Server: Msg 15110, Level 16, State 1, Procedure sp_changedbowner, Line 46
The proposed new database owner is already a user in the database.
Thanks in Advance
Reddy
Sp_changedbowner 'sa'
Jul 30, 2002When I run this command I get:
Server: Msg 15110, Level 16, State 1, Procedure sp_changedbowner, Line 46
The proposed new database owner is already a user in the database.
For each database user name 'dbo' already has a login name of 'sa'.
How do I get the dbowner to be 'sa'?
TIA,
Al
Sp_changedbowner 'NT AUTHORITYSYSTEM'
Aug 16, 2007I have a situation where the database owner was [NT AUTHORITYSYSTEM], and it was changed to "sa."
Now, it must be changed back to [NT AUTHORITYSYSTEM] to prove/disprove an issue. This login is in the SecurityLogins area, and is a System Administrator. The server is SQL 2000.
Yet, I cannot seem to find suitable syntax to do this... is this possible?
sp_changedbowner 'NT AUTHORITYSYSTEM'
sp_changedbowner '[NT AUTHORITYSYSTEM]'
sp_changedbowner [NT AUTHORITYSYSTEM]
sp_changedbowner 'SYSTEM'
sp_changedbowner 'LocalSystem'
Server: Msg 15007, Level 16, State 1, Procedure sp_changedbowner, Line 33
The login 'x' does not exist.
(No alternative workarounds involving making the user a db_owner, please.)
Sp_changedbowner After Mirroring?
Mar 7, 2007We're using Mirroring in our production environment, and we're pretty happy with it.
After failing over, we find that permissions are not correct; especially if the mirror has become the primary and the primary has become the mirror. In particular, we find that we'll need to use sp_changedbowner to reset the ownership of the database.
Why is this? We'd like fail over to just work, and bring the database back up without user intervention.
Sp_changedbowner Gives Error 15110
Jul 20, 2005My platform is NT2000 and my database runs on a SqlServer 2000.I have a database where some of the user tables are owned by theuser dbo. I would like to change the user from dbo to anotheraccount. When I execute the sp_changedbowner to change the table ownerI get the following error message:Msg 15110, Level 16, State 1, Proceduresp_changedbowner, Line 47 The proposed new database owner is already auser in the database.Does anyone know why we get this error message ? What is the bestapproachto fix or get around this problem ? I have seen several posts on thissubjectin this news group that address this issue but I am not sure whichapproachis the recommended or the safest approach.Thanks,Sam
View 2 Replies View Related