views:

30

answers:

1

i got error when i run exec sp_changeobjectowner 'testtable','dbo' 'testtable' table - Unable to modify table.
The object with name "testtable" already exists.

+1  A: 

This exception occurs if the user in context already owned the table object.

Follow this link

Try using this syntax..

EXEC sp_changeobjectowner 'CurrentOwner.youTableName', 'dbo'

S M Kamran