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 3, 2010 at 8:22 am

    #1201571

    I just ran this:

    ALTER SCHEMA sk TRANSFER dbo.Names

    That ran without issue on a SQL 2008 system running build 2734 (SP1 CU6 I believe).

    What is the owner of your schema? dbo was the owner of my sk schema.

    Steve