RE: [Emerald] consolidation errors - update #1

Ronnie D. Franklin ( ronnie@itexas.net )
Tue, 16 Feb 1999 20:34:13 -0600

Ok.. any easy way search through all the records and find the one or
multiples???

> -----Original Message-----
> From: emerald-request@iea-software.com
> [mailto:emerald-request@iea-software.com]On Behalf Of Dale E. Reed Jr.
> Sent: Tuesday, February 16, 1999 5:50 PM
> To: emerald@iea-software.com
> Subject: Re: [Emerald] consolidation errors - update #1
>
>
>
>
> "Ronnie D. Franklin" wrote:
> >
> > I tried to create the keys as directed..., and get the
> following error when
> > I try to save the table:
> >
> > Create unique index aborted on duplicate key. Primary key is '40'
> >
> > > In Enterprise Manager, Edit the CallHistory table, Click the Advanced
> > > Features Button, and go to the Primary Key tab. Click on the
> > > remove table, and then select the first five fields in order, select
> > > non-clustered index, and click add. Finally click save to save the
> > > table changes.
>
> This means there are two records in the database that have the same data
> for the fields you are specifying in the Primary key. You have to
> remove
> one of them before you can create the primary key.
>
> --
>
> Dale E. Reed Jr. Emerald and RadiusNT
> __________________________________________
> IEA Software, Inc. www.iea-software.com
>
> For more information about this list, including removal,
> please see http://www.iea-software.com/maillist.html
>

For more information about this list, including removal,
please see http://www.iea-software.com/maillist.html