Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Strange Indexes in Interprise Manager
Message
From
26/03/2003 09:58:39
 
 
To
All
General information
Forum:
Microsoft SQL Server
Category:
Other
Title:
Strange Indexes in Interprise Manager
Miscellaneous
Thread ID:
00770207
Message ID:
00770207
Views:
58
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?
Next
Reply
Map
View

Click here to load this message in the networking platform