use master go if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[uspDisableAllTrigger]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[uspDisableAllTrigger] GO CREATE PROCEDURE [dbo].[uspDisableAllTrigger] AS declare @objectname varchar(300) DECLARE objectCursor CURSOR local FOR SELECT name FROM sysobjects WHERE type IN ('U') AND status > 0 OPEN objectCursor FETCH NEXT FROM objectCursor INTO @objectname WHILE (@@fetch_status <> -1) BEGIN print @objectname exec( 'ALTER TABLE ' + @objectname + ' DISABLE TRIGGER ALL') FETCH NEXT FROM objectCursor INTO @objectname END DEALLOCATE objectCursor go