Hi 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
what is the proper command for using sp_changedbowner? what all do i need to specify? is it just sp_changedbowner @loginname?
View 2 Replies View RelatedWhen 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
I 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.)
We'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.
My 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