I have a SQL where jobs keep failing due to index being already present.

[SQLSTATE 01000] (Message 50000)  Creating CRM_CreateChangeCompany  [SQLSTATE 01000] (Message 50000)  if not exists (select * from [Replication].[SysIndexes] where name = ‘CRM_CreateChangeCompany’)  begin              create index CRM_CreateChangeCompany on [PROD_Replica].[dbo].[COMPANY] (CREATE_DATE, CHANGE_DATE, COMPANY_NO)        exec LogMessage @procedure = ‘EnsureIndexExists’, @message = ‘Created Index CRM_CreateChangeCompany’  end     

Any help and assistance would be great!

​I have a SQL where jobs keep failing due to index being already present.[SQLSTATE 01000] (Message 50000)  Creating CRM_CreateChangeCompany  [SQLSTATE 01000] (Message 50000)  if not exists (select * from [Replication].[SysIndexes] where name = ‘CRM_CreateChangeCompany’)  begin              create index CRM_CreateChangeCompany on [PROD_Replica].[dbo].[COMPANY] (CREATE_DATE, CHANGE_DATE, COMPANY_NO)        exec LogMessage @procedure = ‘EnsureIndexExists’, @message = ‘Created Index CRM_CreateChangeCompany’  end      Any help and assistance would be great!    Read More

​