Post reply

Need to copy the triggers from on server to another

  • March 10, 2008 at 10:58 am

    #184873

    Hello,

    Please help in letting me know,

    I am trying to copy triggers from OPSAP dtabase in REDBOXC98 for tables T_Sales to OPSAP on ISLRPTSQL,

    Any help is appreciated,

    Thanks,

    Devinder Sohal

  • March 10, 2008 at 11:25 am

    #787514

    In SSMS, expand databases, table in question, triggers. Right-click the trigger in question and select the create to new query window and/or file option.

    Tommy

    Follow @sqlscribe

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

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