SQL Server 2005 - removing table triggers?

How can I remove all triggers from my tables. I have many tables, but about 2开发者_JAVA技巧0 of them have triggers and I want to remove them all.

run this:

SELECT 'DROP TRIGGER ' + name
FROM sysobjects
WHERE type = 'tr'

Then copy the results and run that in the query analyzer. That'll get rid of all the triggers.