Unable to create a Partitioned Indexed View

[silver]

Hi,

While creating an indexed view with the command :

create unique clustered index idx_atrid on account_transactions (policy)

there is a check constraint on the policy column of the tables used in this view.

The following error is encountered

Cannot index the view 'test.dbo.account_transactions'. It contains one or more disallowed constructs.

Can anyone help?

[rmiao]

Did you check 'Restrictions on indexed views' in sql books online? Did you follow those rules when create view?