The upgrade package will check the following database options and try to change them as follows, if necessary. This is required to create filtered indexes.
- SET ANSI_NULLS ON
- SET ANSI_PADDING ON
- SET ANSI_WARNINGS ON
- SET ARITHABORT ON
- SET NUMERIC_ROUNDABORT OFF
- SET QUOTED_IDENTIFIER ON
- SET CONCAT_NULL_YIELDS_NULL ON