IX_OrderGroupNote_OrderGroupId Index issue in database schema upd

IX_OrderGroupNote_OrderGroupId Index issue in database schema update script version 7.0.7

valdis

Vote:

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

Magnus Rahl

Vote:

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

#142759

Dec 22, 2015 7:38

Quan Mai

Vote:

Hi,

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

Regards,

#142760

Dec 22, 2015 7:42

Try our conversational search powered by Generative AI!

IX_OrderGroupNote_OrderGroupId Index issue in database schema update script version 7.0.7