Monday, March 26, 2012

how to change Owner

i want to change the database owner to dbo.rightnow the owner is
test.i want to replace this owner with dbo.
i execute the sp_changeobjectowner 'tbluser' ,'dbo'
while i try to this i got the error
Server: Msg 15001, Level 16, State 1, Procedure
sp_changeobjectowner, Line 38
Object 'tblUser' does not exist or is not a valid object for this
operation.
i login as an 'sa' while trying to perform this operation.
Please let me know how do i change the owner.Try,
sp_changeobjectowner 'test.tbluser' ,'dbo'
Roji. P. Thomas
Net Asset Management
https://www.netassetmanagement.com
"Mustafa" <Mustafa@.discussions.microsoft.com> wrote in message
news:616C728C-4CE0-4F9D-BC3A-947CE7A57388@.microsoft.com...
>i want to change the database owner to dbo.rightnow the owner is
> test.i want to replace this owner with dbo.
> i execute the sp_changeobjectowner 'tbluser' ,'dbo'
> while i try to this i got the error
> Server: Msg 15001, Level 16, State 1, Procedure
> sp_changeobjectowner, Line 38
> Object 'tblUser' does not exist or is not a valid object for this
> operation.
>
> i login as an 'sa' while trying to perform this operation.
> Please let me know how do i change the owner.

No comments:

Post a Comment