don kitchen (1/15/2009)

---

It's probably because you created an index against the AnalysisHolding table when the result was complaining about the Notice table.

Yep, that's embarrassing. 😛 Copy and paste error from two examples of the same problem. The index I meant to post was

CREATE NONCLUSTERED INDEX [IX_Notice_NoticeStageID] ON [Analysis].[Notice]

(

[NoticeStageID] ASC

)

INCLUDE ( [ID],

[AnalysisID],

[FileID])