DISABLE TRIGGER [dbo].[trgDoStuff] ON dbo.MyTable;
GO 

ENABLE TRIGGER [dbo].[trgDoStuff] ON dbo.MyTable;
GO