Disable Constraints / Triggers

-- Constraint:

DECLARE @SQLCommand VARCHAR(MAX)

SET @SQLCommand = ''

SELECT @SQLCommand = ISNULL(@SQLCommand,'') + 'ALTER TABLE ' + QUOTENAME(s.name) + '.' + QUOTENAME(o.name) + ' NOCHECK CONSTRAINT ALL;' + CHAR(13)

FROM sys.objects o

JOIN sys.schemas s

on o.schema_id = s.schema_id

WHERE type = 'U'

PRINT @SQLCommand

EXEC(@SQLCommand) 

-- Trigger

SET @SQLCommand = ''

SELECT @SQLCommand = ISNULL(@SQLCommand,'') + 'ALTER TABLE ' +

QUOTENAME(s.name) + '.' + QUOTENAME(o.name) +

' DISABLE TRIGGER ALL;' + CHAR(13)

FROM sys.objects o

JOIN sys.schemas s

on o.schema_id = s.schema_id

WHERE type = 'U'

PRINT @SQLCommand

EXEC(@SQLCommand)