September 27, 2012 at 8:22 am
In other words - it only matter what the ANSI_PADDING setting was when you created the tables or added the columns. If the server default was changed after the column was created, it wouldn't have changed the behavior.
You might care to start by recreating the table now that you know the ANSI_PADDING is the same on both environments.
Why not first check to see what the setting actually is on each server?
SELECT so.name AS ObjName, sac.name AS ColName, sac.is_ansi_padded, so.type
FROM sys.objects so
INNER JOIN sys.all_columns sac
ON sac.object_id = so.object_id
ORDER BY so.name, sac.name
Reference:
Viewing post 16 (of 16 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy