For checking ANSI_PADDING on columns:
SELECT name column_name,
CASE is_ansi_padded
WHEN 1 THEN 'On'
ELSE 'Off'
AS [ANSI_PADDING]
FROM sys.all_columns
WHERE object_id = object_id(<table name>)
~ Lokesh Vij
Guidelines for quicker answers on T-SQL question[/url]
Guidelines for answers on Performance questions
Link to my Blog Post --> www.SQLPathy.com[/url]
Follow me @Twitter