Home Forums SQL Server 2005 Administering error while trying to move objects from dbo to new schema RE: error while trying to move objects from dbo to new schema

  • August 2, 2010 at 3:34 am

    #1200889

    It seems the issue is specific to SQL server 2008..I tried it on SQL server 2005 and it worked just fine:

    CREATE SCHEMA DBA

    ALTER SCHEMA DBA TRANSFER dbo.myTable

    ALTER SCHEMA DBA TRANSFER dbo.Table1

    --------------------------------------------

    Command(s) completed successfully.