Follow along with the video below to see how to install our site as a web app on your home screen.
Note: This feature may not be available in some browsers.
select name from sysobjects
where id in (select id from syscomments where text like '%SET%QUOTED_IDENTIFIER%ON%')
Declare @v_temp Table (Objectid bigint, objectname varchar(100), xtype varchar(3))
declare @v_temp_count int, @v_i int
insert into @v_temp
select id, name, xtype from sysobjects where xtype in ('U', 'P', 'FN')
order by xtype, name
select @v_temp_count= count(Objectid), @v_i = 0 from @v_temp
select
tmp.ObjectName,
objectproperty (Object_ID(tmp.objectname), 'IsAnsiNullsOn') as 'isansinullsOn',
objectproperty (Object_ID(tmp.objectname), 'IsQuotedIdentOn') as 'isQuotedIdentifiersOn'
FROM
@v_temp tmp
where objectproperty (Object_ID(tmp.objectname), 'IsAnsiNullsOn') = 0 or objectproperty (Object_ID(tmp.objectname), 'IsQuotedIdentOn') = 0