IX_OrderGroupNote_OrderGroupId Index issue in database schema update script version 7.0.7

Member since: 2011

Oringal statement:

IF EXISTS (SELECT name FROM sysindexes WHERE name = 'IX_OrderGroupNote_OrderGroupId')
DROP INDEX IX_OrderGroupNote_OrderGroupId ON [dbo].[OrderGroupNote]
CREATE NONCLUSTERED INDEX [IX_OrderGroupNote_OrderGroupId]
    ON [dbo].[OrderGroupNote]([OrderGroupId] ASC);

GO

Not working very well on SQL Azure. Need to add "." between "sys" and "indexes":

IF EXISTS (SELECT name FROM sys.indexes WHERE name = 'IX_OrderGroupNote_OrderGroupId')
DROP INDEX IX_OrderGroupNote_OrderGroupId ON [dbo].[OrderGroupNote]
CREATE NONCLUSTERED INDEX [IX_OrderGroupNote_OrderGroupId]
    ON [dbo].[OrderGroupNote]([OrderGroupId] ASC);

GO

Production site was down while trying to find this issue :)

#142758 Dec 22, 2015 0:03
  • Member since: 2008

    Thanks for reporting it, I'll register a bug and make sure it is fixed ASAP.

    #142759 Dec 22, 2015 7:38
  • Member since: 2011

    Hi,

    Thank you for your feedback. We'll look into this problem.

    Regards,

    /Q

    #142760 Dec 22, 2015 7:42