-- SCRIPT PARA CAMBIAR LOS INDICES PRIMARIOS DEL C_MV_CPTEXXXXX -- Completar secuencua ALTER TABLE C_MV_CPTEINSUMOS DISABLE TRIGGER ALL UPDATE C_MV_CPTEINSUMOS SET SECUENCIA = ID WHERE SECUENCIA IS NULL Or SECUENCIA = 0 ALTER TABLE C_MV_CPTEINSUMOS ENABLE TRIGGER ALL ALTER TABLE C_MV_CPTETAREAS DISABLE TRIGGER ALL UPDATE C_MV_CPTETAREAS SET SECUENCIA = ID WHERE SECUENCIA IS NULL Or SECUENCIA = 0 ALTER TABLE C_MV_CPTETAREAS ENABLE TRIGGER ALL ALTER TABLE C_MV_CPTE_OBSERV DISABLE TRIGGER ALL UPDATE C_MV_CPTE_OBSERV SET SECUENCIA = ID WHERE SECUENCIA IS NULL Or SECUENCIA = 0 ALTER TABLE C_MV_CPTE_OBSERV ENABLE TRIGGER ALL -- CAMBIO PK INSUMOS ALTER TABLE dbo.C_MV_CpteInsumos DROP CONSTRAINT PK_C_MV_CpteInsumos ALTER TABLE dbo.C_MV_CpteInsumos ADD CONSTRAINT PK_C_MV_CpteInsumos PRIMARY KEY CLUSTERED ( TC, IDCOMPROBANTE, CUENTA, IDARTICULO, Secuencia ) ON [PRIMARY] -- CAMBIO PK TAREAS ALTER TABLE dbo.C_MV_CpteTareas DROP CONSTRAINT PK_C_MV_CpteTareas ALTER TABLE dbo.C_MV_CpteTareas ADD CONSTRAINT PK_C_MV_CpteTareas PRIMARY KEY CLUSTERED ( TC, IDCOMPROBANTE, CUENTA, IDTAREA, Secuencia ) ON [PRIMARY] -- CAMBIO PK OBSERVACIONES BEGIN TRANSACTION SET QUOTED_IDENTIFIER ON SET ARITHABORT ON SET NUMERIC_ROUNDABORT OFF SET CONCAT_NULL_YIELDS_NULL ON SET ANSI_NULLS ON SET ANSI_PADDING ON SET ANSI_WARNINGS ON COMMIT BEGIN TRANSACTION ALTER TABLE dbo.C_MV_CPTE_OBSERV DROP CONSTRAINT FK_C_MV_CPTE_OBSERV_C_MV_Cpte GO COMMIT BEGIN TRANSACTION ALTER TABLE dbo.C_MV_CPTE_OBSERV DROP CONSTRAINT DF_C_MV_CPTE_OBSERV_Transmision GO ALTER TABLE dbo.C_MV_CPTE_OBSERV DROP CONSTRAINT DF_C_MV_CPTE_OBSERV_Recepcion GO ALTER TABLE dbo.C_MV_CPTE_OBSERV DROP CONSTRAINT DF_c_mv_cpte_observ_Secuencia GO CREATE TABLE dbo.Tmp_C_MV_CPTE_OBSERV ( ID int NOT NULL IDENTITY (1, 1), TC nvarchar(4) NOT NULL, IDCOMPROBANTE nvarchar(13) NOT NULL, CUENTA nvarchar(15) NOT NULL, TIPO_OBS nvarchar(2) NOT NULL, OBSERVACION ntext NULL, IMPORTE money NULL, IMPORTE_S_IVA money NULL, Transmision int NULL, Recepcion int NULL, Secuencia int NOT NULL ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO ALTER TABLE dbo.Tmp_C_MV_CPTE_OBSERV ADD CONSTRAINT DF_C_MV_CPTE_OBSERV_Transmision DEFAULT (0) FOR Transmision GO ALTER TABLE dbo.Tmp_C_MV_CPTE_OBSERV ADD CONSTRAINT DF_C_MV_CPTE_OBSERV_Recepcion DEFAULT (0) FOR Recepcion GO ALTER TABLE dbo.Tmp_C_MV_CPTE_OBSERV ADD CONSTRAINT DF_c_mv_cpte_observ_Secuencia DEFAULT (0) FOR Secuencia GO SET IDENTITY_INSERT dbo.Tmp_C_MV_CPTE_OBSERV ON GO IF EXISTS(SELECT * FROM dbo.C_MV_CPTE_OBSERV) EXEC('INSERT INTO dbo.Tmp_C_MV_CPTE_OBSERV (ID, TC, IDCOMPROBANTE, CUENTA, TIPO_OBS, OBSERVACION, IMPORTE, IMPORTE_S_IVA, Transmision, Recepcion, Secuencia) SELECT ID, TC, IDCOMPROBANTE, CUENTA, TIPO_OBS, OBSERVACION, IMPORTE, IMPORTE_S_IVA, Transmision, Recepcion, Secuencia FROM dbo.C_MV_CPTE_OBSERV (HOLDLOCK TABLOCKX)') GO SET IDENTITY_INSERT dbo.Tmp_C_MV_CPTE_OBSERV OFF GO DROP TABLE dbo.C_MV_CPTE_OBSERV GO EXECUTE sp_rename N'dbo.Tmp_C_MV_CPTE_OBSERV', N'C_MV_CPTE_OBSERV', 'OBJECT' GO CREATE NONCLUSTERED INDEX IX_C_MV_CPTE_OBSERV ON dbo.C_MV_CPTE_OBSERV ( TC, IDCOMPROBANTE, CUENTA ) WITH FILLFACTOR = 90 ON [PRIMARY] GO ALTER TABLE dbo.C_MV_CPTE_OBSERV ADD CONSTRAINT PK_C_MV_CPTE_OBSERV PRIMARY KEY CLUSTERED ( TC, IDCOMPROBANTE, CUENTA, TIPO_OBS, Secuencia ) ON [PRIMARY] GO ALTER TABLE dbo.C_MV_CPTE_OBSERV WITH NOCHECK ADD CONSTRAINT FK_C_MV_CPTE_OBSERV_C_MV_Cpte FOREIGN KEY ( TC, IDCOMPROBANTE, CUENTA ) REFERENCES dbo.C_MV_Cpte ( TC, IDCOMPROBANTE, CUENTA ) NOT FOR REPLICATION GO ALTER TABLE dbo.C_MV_CPTE_OBSERV NOCHECK CONSTRAINT FK_C_MV_CPTE_OBSERV_C_MV_Cpte GO COMMIT