> To reproduce the problem, run the following script in AdventureWorks.
>
> CREATE UNIQUE NONCLUSTERED INDEX [IX_ProductReview_Test] ON
> [Production].[ProductReview] ([ProductID] ASC, [ReviewerName] ASC)
> INCLUDE (
> [ProductReviewID]) WITH (PAD_INDEX  = OFF, SORT_IN_TEMPDB = OFF,
> DROP_EXISTING = OFF, IGNORE_DUP_KEY = OFF, ONLINE = OFF) ON [PRIMARY]
>
> Script the database by right-clicking AdventureWorks, choose Tasks,
> Generate Scripts, turn off IF NOT EXISTS, and turn on Indexes.  Select
> Tables and Select All. >
> The script generated for the index is as follows.
>
> CREATE UNIQUE NONCLUSTERED INDEX [IX_ProductReview_Test] ON
> [Production].[ProductReview] ([ProductReviewID] ASC, [ReviewerName] ASC)
> INCLUDE ( [ProductID]) WITH (PAD_INDEX  = OFF, IGNORE_DUP_KEY = OFF) ON
> [PRIMARY]
>
> The ProductReviewID and ProductID fields are reversed.  The problem does
> not occur if the index is created without the UNIQUE option.