v8 - t_diagramtypest_diagram - wrong index checked

[Paolo F Cantoni]

The new V8 Index pack for SQL Server (MSSQLScriptUpdatePatch_2005-8.xml) includes the snippet:

Code: [Select]

IF EXISTS (SELECT 1 FROM dbo.sysindexes WHERE OBJECT_NAME(id) = 't_diagram' AND name = 'Diagram_Type')
DROP INDEX [t_diagram].[t_diagramtypest_diagram]
This checks for the existence of one index than deletes a different one!

The snippet should read:

Code: [Select]

IF EXISTS (SELECT 1 FROM dbo.sysindexes WHERE OBJECT_NAME(id) = 't_diagram' AND name = 't_diagramtypest_diagram')
DROP INDEX [t_diagram].[t_diagramtypest_diagram]to delete the superfluous index.

(I haven't checked the Beta2 - but I wouldn't expect it to have changed)

Reported,
Paolo

[Geert Bellekens]

Paolo,

I've reported this a couple of weeks ago and they assured me that it was fixed and that the download was updated.
I haven't checked myself yet.

Geert

[Paolo F Cantoni]

Paolo,

I've reported this a couple of weeks ago and they assured me that it was fixed and that the download was updated.
I haven't checked myself yet.

Geert

Now checked and it has been fixed...

I've asked for some date or versioning indication to be attached so that we can see when changes have been made since the last download.

Paolo

[Geert Bellekens]

I've asked for some date or versioning indication to be attached so that we can see when changes have been made since the last download.

Paolo

That would indeed be a good idea.

Geert