I created a fulltext catalog using the following command.
CREATE FULLTEXT CATALOG [DMSRepositoryFTCat] WITH ACCENT_SENSITIVITY = ON
Before I can create a full-text index on the VIEW , I am trying to create a Unique Index using the following command.
CREATE UNIQUE INDEX UI_DMS_REP_ID ON DMS_MANAGEMENT_REPOSITORY_VIEW(ID)
But I am getting the error "Cannot create index on view 'DMS_MANAGEMENT_REPOSITORY_VIEW'. It does not have a unique clustered index."
How can I create a Unique Cluster Index on the view DMS_MANAGEMENT_REPOSITORY_VIEW which has outer join within it. or is there something I am doing wrong.
I am attaching the view script aswell.