Microsoft SQL Server 2012 - 11.0.5058.0 (X64) 
	May 14 2014 18:34:29 
	Copyright (c) Microsoft Corporation
	Enterprise Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1) (Hypervisor)

Message
DELETE failed because the following SET options have incorrect settings: 'CONCAT_NULL_YIELDS_NULL, ANSI_WARNINGS, ANSI_PADDING'. Verify that SET options are correct for use with indexed views and/or indexes on computed columns and/or filtered indexes and/or query notifications and/or XML data type methods and/or spatial index operations.

  SET ANSI_NULLS, ANSI_PADDING, ANSI_WARNINGS, ARITHABORT, CONCAT_NULL_YIELDS_NULL, QUOTED_IDENTIFIER ON
  SET NUMERIC_ROUNDABORT OFF
CREATE INDEX ....

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
  SET ANSI_NULLS, ANSI_PADDING, ANSI_WARNINGS, ARITHABORT, CONCAT_NULL_YIELDS_NULL, QUOTED_IDENTIFIER ON
  SET NUMERIC_ROUNDABORT OFF
GO

ALTER PROCEDURE [adm].[StartupEx]
as
BEGIN
  SET NOCOUNT ON;
/*
  SET ANSI_NULLS, ANSI_PADDING, ANSI_WARNINGS, ARITHABORT, CONCAT_NULL_YIELDS_NULL, QUOTED_IDENTIFIER ON
  SET NUMERIC_ROUNDABORT OFF
*/
  DELETE FROM [dbo.[TableWithFilteredIndex] 
END
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
  SET ANSI_NULLS, ANSI_PADDING, ANSI_WARNINGS, ARITHABORT, CONCAT_NULL_YIELDS_NULL, QUOTED_IDENTIFIER ON
  SET NUMERIC_ROUNDABORT OFF
GO
ALTER PROCEDURE [adm].[Startup]
AS
BEGIN
  exec [adm].[StartupEx]
END