November 23, 2004 at 12:55 pm
We have a couple of tables that have been created with clustered indexes using allow_dup_row. When I compile the proc I get an error that says: "CREATE INDEX option 'allow_dup_row' is no longer supported". Does anyone know of a workaround? From what I've read this feature is no longer compatible as of SQL 7.0. Thanks in advance for your help!
November 23, 2004 at 2:32 pm
I believe it is just a syntax change. You can still "allow dups" by just not saying "UNIQUE" in the create index statement.
November 23, 2004 at 2:39 pm
Are you still in SQL Server 6.5?
November 23, 2004 at 2:44 pm
No. Were running at compatibility level 80. The syntax that is failing is as followed: create clustered index i1 on table_name(tm) with allow_dup_row
November 23, 2004 at 3:04 pm
just delete the "with allow_dup_row"... it will work. (Or at least it does for me.)
November 24, 2004 at 12:38 am
Yes, removing the "with allow_dup_row"... should do it. SQL Server will internally add the uniqueifier when necessary to mark a single row as unique.
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
February 5, 2008 at 5:13 am
Can we have duplicate value in the clustered index column?
February 5, 2008 at 5:28 am
Can we have duplicate value in the clustered index column in sql 2k5?
February 5, 2008 at 10:12 am
Yes - if you don't make your clustered index unique, you certainly can have dupes in your clustered index Keys. To account for that, SQL will add some hidden value to the end of each key to make it unique.
----------------------------------------------------------------------------------
Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply