I have 6 tables in a SQL2kSP3 Database, when viewing the "Table Info" tab of a "Taskpad" view of the DB, all may tables have indexes listed that I didn't create. The indexes are in the format
_WA_Sys_BorderID_1975C517 I tried a "DROP INDEX" but got the message
"Cannot drop the index 'BOMITEMS._WA_Sys_BorderID_1975C517', because it does not exist in the system catalog."I have a copy of this database that gets updated every day, that I use for test purposes, and it
doesn't display the same behavior. It appears to only be on the Live database that is regularly updated for my VFP7.0SP1 app. Which I might add seems to run fine.
Any Ideas.
Thanks
Jon
Non-MVP Non-MCP Non-MCSE
Visual FoxPro, What else is there?