• Hi Arju,

    Sorry for reply to0 late. Please check the below link. this will help you.

    http://www.sqlservercentral.com/scripts/T-SQL/97571/

    I have also create different kind of scripts related to copy objects from one schema to another schema.

    You can check my other scripts.

    Thanks
    Vinay Kumar
    -----------------------------------------------------------------
    Keep Learning - Keep Growing !!!