Sunday, February 19, 2012

ALLOW_DUP_ROW is no longer supported

Any body please give me the details about how to use 'ALLOW_DUP_ROW' in a CREATE CLUSTERED INDEX statement.

I tried executing the below statement but it throws an error "CREATE INDEX option 'ALLOW_DUP_ROW' is no longer supported."(both in SQL Server 2000 and SQL Server 2005)

CREATE CLUSTERED INDEX index121
ON raj(j)
WITH ALLOW_DUP_ROW

raj(j) contains two rows with same value

please hhelp me outneed a quick help ,|||Clustered indexes allow duplicate rows by default. You have to create it as a primary key or add a unique constraint in order to prevent duplicate rows.

No comments:

Post a Comment