/****** Script for SelectTopNRows command from SSMS  ******/

SELECT TOP 1000 [OFFRCD_STATUS_ID]

      ,[OFFRCD_STATUS_NAME]

  FROM [ALU_E2E_Database_W1].[dbo].[RFA_STATUS]

  delete from [ALU_E2E_Database_W1].[dbo].[RFA_STATUS]

  where OFFRCD_STATUS_ID = 7

  DBCC CHECKIDENT ("[ALU_E2E_Database_W1].[dbo].[RFA_STATUS]",RESEED,5);

  go

INSERT INTO [ALU_E2E_Database_W1].[dbo].[RFA_STATUS]

           ([OFFRCD_STATUS_NAME])

     VALUES

           ('UNPUBLISH')

GO