Index - error

Index - error

Post by Liana Chi » Tue, 04 Dec 2001 21:48:00

how can I intercept and trait one error for duplicated values in one unique



Index - error

Post by Stu » Wed, 05 Dec 2001 01:54:03

You first need to identify duplicate rows. Assuming this

(   MyKey int PRIMARY KEY,
    SomeValue varchar(200) NOT NUL

Assume that you want to build a UNIQUE index on SomeValue,
but you get an error message indicating that one or more
values are not unique. You could identify those rows with
this query:

SELECT MyKey, SomeValue FROM MyTable WHERE SomeValue IN
(SELECT SomeValue, COUNT(*) FROM MyTable

How you proceed from that point depends on what you need
to do -- delete the duplicate rows, change SomeValue to
make it unique, etc.

Stu Bloom, MCSD

Quote:>-----Original Message-----
>how can I intercept and trait one error for duplicated

values in one unique




1. Index Error - Index out date

When I open a Tbale, for reindex and pack, sometimes one error occur.

This message appears:  "index out date"

The table not open in exclusive mode.

There're a code for open the table and reindex and pack???

Best regrads..

****************************** En espa?ol
Cuando abro una tabla para reindexar, algunas veces me ocurre un

El mensaje es el siguuiente : "Index out date"

Por tanto, no puedo abrir la tabla en modo exclusivo.

Hay alguna manera de volver a reindexar la tabla, y corregir el error.

Muchas gracias,
= Apache Salas Rock                                       =

=    2:346/15.10                                            =  
        Me comunico, luego existo.....

2. table corruption problem

3. PDOX5, OPAL, error trapping for index errors?

4. Database Desktop - HELP!!

5. BCP: --- Invalid Descriptor Index Error ... need help

6. Free 70-029 practice test

7. table corrupted with clustered index error

8. cant get memo

9. Fulltext Index Error

10. Need Help - 1505 Index Error

11. Composite index error on alter table statement

12. Index Error -- Please help

13. Full Text Indexing Error