Ansi_pading

Question

Hi,

I've seen that Ansi_Padding is going to be ON always from next versions of SQL Server. So is there any alternative setting to trim those trailing spaces. I know we can use trim function to do but what if we got to do it on all the columns we have in there and what is we have more columns?

So do we have any setting alternative to Ansi_Padding?

Answer 1

This is a warning which you should be coding for already; this feature has been deprecated for years.  Note that it is deprecated but there is no guarantee that the next version of sql server WILL remove the functionality - the announcement only means that it will eventually be removed.  If you want data trimmed automatically, you need to code for it - and start doing that now.

 You have had years to code for it correctly; I suggest you start the process sooner rather than later.  Triggers are an alternative, but it must be on for certain features to work.   If you want to use those features - indexed view are pretty basic and very useful - triggers will not help you.