Important Notice from AspDotNetStorefront
It is with dismay that we report that we have been forced, through the action of hackers, to shut off write-access to this forum. We are keen to leave the wealth of material available to you for research. We have opened a new forum from which our community of users can seek help, support and advice from us and from each other. To post a new question to our community, please visit: http://forums.vortx.com
Results 1 to 4 of 4

Thread: Dropping the index from the Customer Table

  1. #1
    srijans is offline Junior Member
    Join Date
    Jul 2010
    Posts
    11

    Default Dropping the index from the Customer Table

    Hi All,

    I am trying to drop the index "UIX_Customer_CustomerGUID" on the Customer table. I am not able to do that. I am logged in with the admin login and still I get the error "Cannot drop the index 'Customer.CustomerID.UIX_Customer_CustomerGUID', because it does not exist or you do not have permission.".

    Please guide me in this.

    Thanks In Advance
    Sriram.

  2. #2
    esedirect is offline Senior Member
    Join Date
    Feb 2010
    Location
    Norfolk, UK
    Posts
    343

    Default

    What SQL statement are you using to drop the index?
    http://www.esedirect.co.uk
    --------------------------------------------------------------------------
    Using MS 9.2.0.0 with the following customisations:

    Lightbox/Fancybox enlarged images;
    Auto-suggest searchbox;
    Extra product information shown only to our IP Address (such as supplier info, costs, etc.);
    Failed transactions emailed via trigger;
    Custom app to show basket contents when customer online;
    Orders pushed through to accounting systems.

    All the above without source!

  3. #3
    srijans is offline Junior Member
    Join Date
    Jul 2010
    Posts
    11

    Default

    Hi,

    I am using the following code

    drop index UIX_Customer_CustomerGUID ON Customer.CustomerID

    drop index UIX_Customer_CustomerGUID ON Customer.CustomerGUID

  4. #4
    esedirect is offline Senior Member
    Join Date
    Feb 2010
    Location
    Norfolk, UK
    Posts
    343

    Default

    That's why it's not working. Where did you get that from? You probably need:

    Code:
    DROP INDEX [UIX_Customer_CustomerGUID] ON [dbo].[Customer]
    GO
    http://www.esedirect.co.uk
    --------------------------------------------------------------------------
    Using MS 9.2.0.0 with the following customisations:

    Lightbox/Fancybox enlarged images;
    Auto-suggest searchbox;
    Extra product information shown only to our IP Address (such as supplier info, costs, etc.);
    Failed transactions emailed via trigger;
    Custom app to show basket contents when customer online;
    Orders pushed through to accounting systems.

    All the above without source!