Post reply

Dropping all triggers in a database

  • March 15, 2008 at 5:38 am

    #180194

    Please tell me how to drop all the triggers in a database??

  • March 15, 2008 at 9:24 am

    #790004

    Are you sure you want to do this? What about DDL triggers? Are you 100% sure you know what every trigger does?

    Look in sys.triggers, loop through the results and use DROP to remove them.

    You can also DISABLE ALL, which will stop them from firing.

  • March 16, 2008 at 8:57 am

    #790141

    thanks a lot...

    i wanted this because i have created a db just to archive all the projects. so i just want to dump all the data thats it... i didnt want any problems while inserting the data into the tables. hence i needed this. anyways i got it :).

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

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