Тестирование и отладка БД средствами SQL SERVER

DECLARE @cur CURSOR
DECLARE @constName NVARCHAR(255)
DECLARE @tableName NVARCHAR(255)
DECLARE @constID INT
DECLARE @query NVARCHAR(600)
SET @query=N'ALTER TABLE @table CHECK CONSTRAINT @const'
 
SET @cur =CURSOR READ_ONLY FAST_FORWARD FORWARD_ONLY
FOR
    WITH CTECONSTRAINTS(name,constName,parent_object_id)
    AS(
        SELECT name,object_id,parent_object_id FROM sys.foreign_keys    WHERE is_disabled=0
        UNION ALL
        SELECT name,object_id,parent_object_id FROM sys.check_constraints   WHERE is_disabled=0
    )
    SELECT _c.name,_c.constName,_s.name+'.'+_t.name
    FROM CTECONSTRAINTS AS _c
    JOIN sys.tables AS _t
        ON _t.object_id=_c.parent_object_id
    JOIN sys.schemas AS _s
        ON _s.schema_id=_t.schema_id
 
OPEN @cur
 
FETCH NEXT FROM @cur INTO @constName,@constID,@tableName
 
WHILE @@FETCH_STATUS=0
BEGIN
    BEGIN TRY
        SET @query=N'ALTER TABLE '+ @tableName+' WITH CHECK CHECK CONSTRAINT '+ @constName;
        EXECUTE sp_executesql @query;
    END TRY
    BEGIN CATCH
        SELECT ERROR_MESSAGE(),@tableName,@constName,text FROM sys.syscomments where id= @constID
    END CATCH
    FETCH NEXT FROM @cur INTO @constName,@constID,@tableName
END;
 
CLOSE @cur
DEALLOCATE @cur