I have to increase DataType Size for few columns .. in a Table which has records in it.
Create Table has below Syntax in it.
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
SET ANSI_PADDING ON
When i tried to Alter the Table, I get an error as
Msg 1934, Level 16, State 1, Procedure Capture_objects_changed, Line 18
INSERT failed because the following SET options have incorrect settings: '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.
Experts, Kindly help me to resolve this issue.