Create unique clustered index error 8662

Experts,
Error 8662 is not allowing me to create a unique CLUSTERED INDEX  on a table.  Can some one please advise.
SQL 2000.

CREATE UNIQUE CLUSTERED INDEX
INDEX NAME
ON DBO.TABLE NAME
(
COLUMN1, COLUMN2, COLUMN
)
Thanks!
Rainbow002Asked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
Guy Hengel [angelIII / a3]Connect With a Mentor Billing EngineerCommented:
not sure which error that is exactly, but there are only this reasons I know of off the top of my hat:
* there is already a clustered index on that table
* there is at least 2 rows that have the same values for column1, column2 and column3
* there is not enough space to create the index, and/or autogrow of the database cannot increase fast enough ...
* there is already a index with the same columns in that order
0
 
Rainbow002Author Commented:
Below is the excat error:
Server: Msg 8662, Level 16, State 1, Line 1
An index cannot be created on the view 'VW_RES_FA_T' because the view definition includes an unknown value (the sum of a nullable expression).

Actually i was creating index on view but just got to know that we can't craete index on a view.  If we have to create one, do we have option to create this on a view.  Thanks!

0
 
Guy Hengel [angelIII / a3]Connect With a Mentor Billing EngineerCommented:
>Actually i was creating index on view but just got to know that we can't craate index on a view.  I
you can, but it requires some conditions to be followed on the views' sql...
here is a good article summing it up:
http://www.sqlteam.com/article/indexed-views-in-sql-server-2000
0
 
Rainbow002Author Commented:
Thanks Angelll
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.