--Migration
IF NOT EXISTS(SELECT 1 FROM sys.indexes WHERE name = 'NCI_Tanev_IntezmenyId2')
BEGIN
  CREATE NONCLUSTERED INDEX [NCI_Tanev_IntezmenyId2] 
  ON [dbo].[T_TANEV](C_INTEZMENYID)
  WHERE (TOROLT = 'F' AND C_AKTIV = 'T')
  WITH (FILLFACTOR = 100)
END