Sql Server One or more existing columns have ANSI_PADDING 'off' and will be re-created with ANSI_PADDING 'on'

SET ANSI_PADDING ON or OFF

Syntax

-- Syntax for SQL Server

SET ANSI_PADDING { ON | OFF }

Solution:

ALTER command:

SET ANSI_PADDING OFF
go
SET ANSI_PADDING ON