1. Home
  2. Cloud & Dedicated Servers
  3. MS SQL
  4. How do I Change a single object to DBO?

How do I Change a single object to DBO?

Step 1

The following stored procedure can be very handy when you need to change the ownership of a table or any other object on your MS SQL database:

EXEC sp_changeobjectowner


Step 2

Here is the Syntax:

EXEC sp_changeobjectowner 'USERname.OBJECTname', 'dbo'

This example changes the owner of the TEST table owned by TESTUSER to DBO.

EXEC sp_changeobjectowner 'TESTUSER.TEST', 'dbo'


Content retrieved from: https://support.appliedi.net/kb/a290/how-do-i-change-a-single-object-to-dbo.aspx.

Updated on November 11, 2019

Was this article helpful?

Related Articles

Need Support?
Can't find the answer you're looking for? Don't worry we're here to help!