Мне нужно добавить 2 CONSTRAINT-a на таблицу.
Если делаю так
ALTER TABLE [dbo].[tCustomers] WITH NOCHECK ADD
CONSTRAINT [CK_tCustomers] CHECK (([cManagedAccount] = 'S' or [cManagedAccount] = 'Y') and [cParent] is null or [cManagedAccount] = 'N')
GO

ALTER TABLE [dbo].[tCustomers] WITH NOCHECK ADD
CONSTRAINT [PK_tCustomers] PRIMARY KEY CLUSTERED
(
[cCustCode]
) ON [PRIMARY]
GO

То все работает, а если так:


ALTER TABLE [dbo].[tCustomers] WITH NOCHECK ADD
CONSTRAINT [PK_tCustomers] PRIMARY KEY CLUSTERED
(
[cCustCode]
) ON [PRIMARY],
CONSTRAINT [CK_tCustomers] CHECK (([cManagedAccount] = 'S' or [cManagedAccount] = 'Y') and [cParent] is null or [cManagedAccount] = 'N')

GO

Получаю ошибки (это не опечатка, их действительно 4):

Server: Msg 433, Level 16, State 1, Line 1
Could not find CHECK constraint for 'dbo.tCustomers', although the table is flagged as having one.
Server: Msg 433, Level 16, State 1, Line 1
Could not find CHECK constraint for 'dbo.tCustomers', although the table is flagged as having one.
Server: Msg 433, Level 16, State 1, Line 1
Could not find CHECK constraint for 'dbo.tCustomers', although the table is flagged as having one.
Server: Msg 433, Level 16, State 1, Line 1
Could not find CHECK constraint for 'dbo.tCustomers', although the table is flagged as having one.


Поскольку код для добавления CONSTRAINT создал Enterprice Manager
а таких таблиц больше 20-ти, и исполнять подобный скрипт нужно регулярно,
то каждый Alter разбивать на 2 будет затруднительно