SQL Server is adding a check constraint to my nocheck constraint.

I start with this:

```
ALTER TABLE [dbo].[Subjects]  WITH NOCHECK ADD  CONSTRAINT [FK_Subject_OrganizationSubjectRank] FOREIGN KEY([OrganizationId], [StatusId], [Rank])
REFERENCES [dbo].[OrganizationSubjectRanks] ([OrganizationId], [OrganizationSubjectStatusId], [Name])
GO

```

And SQL server adds this to my code every time I execute:

```
ALTER TABLE [dbo].[Subjects] CHECK CONSTRAINT [FK_Subject_OrganizationSubjectRank]
GO

```

This is causing foreign key constraint errors.

How do I prevent SQL server from adding this check constraint to my code?