Sp_changedbowner 'sa'

Jul 30, 2002

When 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

View 2 Replies


ADVERTISEMENT

Sp_changedbowner

Apr 24, 2001

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 Related

Sp_changedbowner

Jan 12, 2001

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

View 1 Replies View Related

Sp_changedbowner 'NT AUTHORITYSYSTEM'

Aug 16, 2007

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.)

View 3 Replies View Related

Sp_changedbowner After Mirroring?

Mar 7, 2007

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.

View 3 Replies View Related

Sp_changedbowner Gives Error 15110

Jul 20, 2005

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







Copyrights 2005-15 www.BigResource.com, All rights reserved