Post reply

COPYING ALL DA THE DATBASE OBJECTS FROM DBO SCHEMA TO NEW SCHEMA

  • June 8, 2010 at 3:30 pm

    #147486

    HI,

    I DETTACHED/ATTACHED A DATABASE FROM 2000 TO 2008.I AM PLANNING TO MOVE ALL THE DATABASE OBJECT FROM DBO SCHEMA TO A NEW SCHEMA "ABCD".I KNOW A PROCESS WHERE I CAN MOVE EACH DATABASE OBJECT INDIVIDUALLY,BUT I AM DEALING HERE WITH more than 300 tables and 400+ stored procedures etc etc.can anyone help me with a different solution where i can do that quickly.thank you.

  • June 9, 2010 at 1:42 am

    #1177827

    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."

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply