i got error when i run exec sp_changeobjectowner 'testtable','dbo'
'testtable' table
- Unable to modify table.
The object with name "testtable" already exists.
views:
30answers:
1
+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
2009-12-09 06:28:00