Home Forums SQL Server 2008 SQL Server 2008 Administration Change the Owner of a Table RE: Change the Owner of a Table

  • February 23, 2013 at 10:33 am

    #1590610

    AndrewSQLDBA (2/23/2013)

    I would like the change the owner of all tables in a database from 'dbo' to 'Test'.

    Do you want to change the owner of the table or do you want to move it to a different schema? Huge difference between the two.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass