To further add (SQL Server 2012 BOL):

In a future version of Microsoft SQL Server ANSI_PADDING will always be ON and any applications that explicitly set the option to OFF will produce an error. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.

Source: http://msdn.microsoft.com/en-us/library/ms187403.aspx