Comments
Sort by recent activity
-- See BOL for extact definitions
select type, name, objectproperty( object_id(name),'IsAnsiNullsOn') IsAnsiNullsOn, objectproperty( object_id(name),'ExecIsAnsiNullsOn') ExecIsAnsiNullsOn
from sysobjects
-- Exclude types for which these properties don't apply
where type not in ('C', 'D', 'F', 'K')
order by type, name / comments
-- See BOL for extact definitions
select type, name, objectproperty( object_id(name),'IsAnsiNullsOn') IsAnsiNullsOn, objectproperty( object_id(name),'ExecIsAnsiNullsOn') ExecIsAnsiNullsOn
from syso...