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:

1 
EXEC sp_changeobjectowner

 

Step 2


Here is the Syntax:

1 
EXEC sp_changeobjectowner 'USERname.OBJECTname', 'dbo'

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

1 
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!
CONTACT SUPPORT

Leave a Comment