create procedure sp_check_uncheck_fk
@mode int= 0   --0 for uncheck,  otherwise for check
 
As

DECLARE @SQLText nvarchar( 4000 )

DECLARE cur cursor for 
	Select 
		'ALTER TABLE '+
		TABLE_NAME+
		CASE
		WHEN @mode= 0  THEN ' nocheck'
		ELSE ' check' 
		END+' constraint '+
		CONSTRAINT_NAME
	from 
		INFORMATION_SCHEMA.TABLE_CONSTRAINTS 
	where 
		CONSTRAINT_TYPE='FOREIGN KEY'

OPEN cur

fetch next from cur into @SQLText

while @@fetch_status= 0 
BEGIN
	execute (@SQLText)
	fetch next from cur into @SQLText
END

CLOSE cur
DEALLOCATE cur 
Go