Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Error while dropping index

Status
Not open for further replies.

vicsap

Technical User
Sep 25, 2006
10
US
I am trying to drop index using:
DROP INDEX Bill_Cycle_ID
ON BI_DM_7.Snapshot_Revenue_By_Bill_Cycle;

and I am getting the following error message:
6952: Indexes cannot be created or dropped during random AMP sample emulation.

I have never seen this error message before.

Please advice
 
disculpame que no te escriba en ingles

Tienes habilitada la opción TLE(Terget level Emulation) una de las opciones que tienes para borrar el indice es cambiar esta propieda a false en la DBSControlUtility, corra DIPPATCH.
When random AMP sample emulation is active for a table indexes cannot droped on that table.




 
Thanks for the reply Varc.
Can you please translate the same in English as I don't know Spanish.

Thanks
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top