Activity overview
Latest activity by vbhackattack
-- 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...
compare database properties
Two questions:
Does SQL Compare handle database properties of the sort that appear in the CREATE DATABASE statement? I want to compare two databases, not the objects within.
Can SQL Compare or SQL ...