Alter Table PolicyProposal Disable trigger all

Update PolicyProposal set AnnuityOptionInternalNo = AnnuityOption.AnnuityOptionInternalNo, AnnuityMode = 'M'
from PolicyProposal
 Join InsurancePlan On PolicyProposal.PlanInternalNo = InsurancePlan.PlanInternalNo
 Join InsuranceTransaction it on PolicyPropInternalNo = it.TransactionInternalNo
 Join AnnuityOption on InsurancePlan.PlanInternalNo = AnnuityOption.PlanInternalNo and DefaultOption = 1 and AnnuityOption.AnnuityOptionInternalNo not in (160)
 Where InsurancePlan.PlanType = 'A'
   and PolicyProposal.AnnuityOptionInternalNo is null and PolicyProposal.AnnuityMode is null

Alter Table PolicyProposal Enable trigger All

DROP INDEX IX_PremiumDuePdf_EmailMessageId ON PremiumDuePdf;
ALTER TABLE PremiumDuePdf ALTER COLUMN EmailMessageId VARCHAR(500) NULL;
CREATE INDEX IX_PremiumDuePdf_EmailMessageId ON PremiumDuePdf (AgencyInternalNo, EmailMessageId);

DROP INDEX IX_Commission_EmailMessageId ON Commission;
ALTER TABLE Commission ALTER COLUMN EmailMessageId VARCHAR(500) NULL;
CREATE INDEX IX_Commission_EmailMessageId ON Commission(AgencyInternalNo, EmailMessageId);

