• OBJECTPROPERTY ( object_id(tablename), 'IsAnsiNullsOn')

    DATABASEPROPERTYEX( youedatabase , 'IsAnsiPaddingEnabled' )

    DBCC USEROPTIONS