The proper syntax should be:

EXEC sp_MSForEachTable 'ALTER TABLE ? NOCHECK CONSTRAINT ALL'

where the ? is been replace for the table name