Rechana Rajan (12/7/2016)
When i script out tables from my local some have ANSI_PADDING ON and some dont have that mentioned before the create table state. Can anyone help me understand why?As per my understanding the ANSI_PADDING is ON by default for char,varchar .I tried to create a table with ANSI_PADDING off and it failed . What are all the scenarios when ANSI_PADDING is OFF.
Why did it fail? It must have given you an error message.
You should be able to create a table with ANSI_PADDING = OFF (not recommended).
Check your settings in the options panel (see attached figure)
Igor Micev,My blog: www.igormicev.com