Search BOL for DISABLE TRIGGER... 🙂
and to check if enabled or disabled see ...
SELECT * FROM sys.triggers
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. Selburg