I set it to FALSE in my Master and in my Target, but the Delta Script sets in ON at the begining.
The main purpose of the upgrade is to set all [char] columns to [nvarchar]
If I manually change this to OFF in the Delta Script the columns are altered and the data is left alone, i.e. No padding added.
But we are planning to use Packager Plus and I think it will also set this ON and I don't know how to ensure it will be OFF.
Any help appreciated.
Mike
I appear to be in error, even after setting it off all data appears to be padded now. There is something I am missing here. I need to do some more research.
I think you problem is because SET ANSI_PADDING is always ON for nchar and nvarchar. SET ANSI_PADDING OFF does not apply to the nchar or nvarchar data types.
A further thought. Could the padding you are seeing in the altered column just be the padding from when the column was fixed length char. This will not be trimmed. You might have to trim it yourself in the after script.
SET ANSI_PADDING ON
Posted - 09/18/2009 : 11:00:19
