Thanks shas3, allen, ian for your replies. Every pointer was useful

shas3, the table is used for interfacing diff applications, so it contains many columns which are just nulls presently but...

Hi shas3,

Thanks for ur prompt reply.It was spot on.

The db giving problems had 251 entries in sysindexes while other one had 7 for

that table !!

In my case i dropped...