ServiceManager.Report.IncidentManagement.Optimizations.Uninstall (Resource)

Element properties:

Source Code:

<Resource ID="ServiceManager.Report.IncidentManagement.Optimizations.Uninstall" Accessibility="Public" FileName="ServiceManager.Report.IncidentManagement.Optimizations.Uninstall.sql"/>

File Content: ServiceManager.Report.IncidentManagement.Optimizations.Uninstall.sql

/****** Object:  Index [nci1_IncidentDim_ClosedDate]    Script Date: 02/11/2010 11:12:08 ******/


IF  EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[IncidentDim]') AND name = N'nci1_IncidentDim_ClosedDate')


DROP INDEX [nci1_IncidentDim_ClosedDate] ON [dbo].[IncidentDim] WITH ( ONLINE = OFF )


GO





/****** Object:  Index [nci2_IncidentDim_CreatedDate]    Script Date: 02/11/2010 11:12:08 ******/


IF  EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[IncidentDim]') AND name = N'nci2_IncidentDim_CreatedDate')


DROP INDEX [nci2_IncidentDim_CreatedDate] ON [dbo].[IncidentDim] WITH ( ONLINE = OFF )


GO





/****** Object:  Index [nci3_IncidentDim_ResolvedDate]    Script Date: 02/11/2010 11:12:08 ******/


IF  EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[IncidentDim]') AND name = N'nci3_IncidentDim_ResolvedDate')


DROP INDEX [nci3_IncidentDim_ResolvedDate] ON [dbo].[IncidentDim] WITH ( ONLINE = OFF )


GO