Index playing hide and seek game

Hi,
I am playing game hide and seek with microsoft sql server 2000 sp4.
I had transfered few schemas of my production server in my OLAP server.
After the transfer completes i transfer data in a BCP files.
Now when i load data from BCP file to my OLAP server table .
It gives erro that duplicate value cannot insert due to index.
so i execute my code to delete the index.
drop index tablename.index
but it doesnot have index.
Now i directly transfered the data from the Production server to OLAP
server throught DTS.
and it finishes fine.
When i query in sysindex i see one entry but no name of the index.
Can any one tell me why it is happening with BCP files.
Hope u will help me
than x
from
Killer
Hi
Posting DDL and sample data may help to explain this.
What is the ID of the entry in sysindexes and what does the following give?
SELECT OBJECT_NAME(id),* FROM sysindexes WHERE ISNULL(name,'') = ''
John
"doller" wrote:

> Hi,
> I am playing game hide and seek with microsoft sql server 2000 sp4.
> I had transfered few schemas of my production server in my OLAP server.
> After the transfer completes i transfer data in a BCP files.
> Now when i load data from BCP file to my OLAP server table .
> It gives erro that duplicate value cannot insert due to index.
> so i execute my code to delete the index.
> drop index tablename.index
> but it doesnot have index.
> Now i directly transfered the data from the Production server to OLAP
> server throught DTS.
> and it finishes fine.
> When i query in sysindex i see one entry but no name of the index.
> Can any one tell me why it is happening with BCP files.
> Hope u will help me
> than x
> from
> Killer
>
sql