Home Forums SQL Server 2005 Administering COPYING ALL DA THE DATBASE OBJECTS FROM DBO SCHEMA TO NEW SCHEMA RE: COPYING ALL DA THE DATBASE OBJECTS FROM DBO SCHEMA TO NEW SCHEMA

  • Check the ALTER AUTHORIZATION (Transact-SQL) which may help you. Refer the following link:

    http://technet.microsoft.com/en-us/library/ms187359.aspx

    HTH

    ---------------------------------------------------
    "Thare are only 10 types of people in the world:
    Those who understand binary, and those who don't."