IX_OrderGroupNote_OrderGroupId Index issue in database schema update script version 7.0.7

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
Vote:
 

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

#142759
Dec 22, 2015 7:38
Vote:
 

Hi,

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

Regards,

/Q

#142760
Dec 22, 2015 7:42
This topic was created over six months ago and has been resolved. If you have a similar question, please create a new topic and refer to this one.