Home Forums SQL Server 2005 Administering Change Object Ownership RE: Change Object Ownership

  • February 5, 2009 at 9:57 am

    #939000

    You might change the schema that owns the object as

    ALTER SCHEMA schema_name TRANSFER object_name

    Thanks!!

    The_SQL_DBA
    MCTS

    "Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."