How to change table ownership to dbo using SQL 2012.

Version 1

    Details

    How to change table ownership to dbo using SQL 2012.


    Resolution

     

    Committing edit sets with SQL accounts other then the ones that own the SQL tables can cause a change in table ownership. This could cause HEAT authentication issues in reference to the authentication account that is being used to access the table/data may not have rights to those tables after this occurs.


    Use the following SQL query for SQL 2012 to change the table ownership. It is recommended that one contact their DBA before making these changes.

    alter schema dbo transfer [BadUser].[NameOfTheTable]

    Note:

    It is recommended that one contact their DBA before making these changes.