SET QUOTED_IDENTIFIER ON SET ARITHABORT ON SET CONCAT_NULL_YIELDS_NULL ON SET ANSI_NULLS ON SET ANSI_PADDING ON SET ANSI_WARNINGS ON SET NUMERIC_ROUNDABORT OFF go DECLARE @bErrors as bit BEGIN TRANSACTION SET @bErrors = 0 CREATE NONCLUSTERED INDEX [MV_PREPARACION_DETALLES8] ON [dbo].[MV_PREPARACION_DETALLES] ([IDCOMPROBANTE] ASC, [IDPREPARACION] ASC ) IF( @@error <> 0 ) SET @bErrors = 1 IF( @bErrors = 0 ) COMMIT TRANSACTION ELSE ROLLBACK TRANSACTION CREATE STATISTICS [hind_1109578991_4A_2A] ON [dbo].[MV_PREPARACION] ([FECHA_FINALIZACION], [IDPREPARACION])