Re: Ansi Nulls and quoted identified

To identify the objects, use something like this:

SELECT name, xtype,
OBJECTPROPERTY(id,'ExecIsAnsiNullsOn'),
OBJECTPROPERTY(id,'ExecIsQuotedIdentOn')
FROM sysobjects WHERE xtype IN ('P','TR','V','IF','FN','TF')

To change these properties, you should re-create those objects using
ALTER PROCEDURE / ALTER VIEW / ALTER FUNCTION.

If you do not want to do this one by one (and if you feel particularly
lucky today, as to change an undocumented column in a system table), I
will give you a hint: bits 30 and 29 (bit mask: 0x60000000) of the
status column in the sysobjects table.

Of course, changing a system table is a bad idea (it may cause data
loss or may prevent an instance of SQL Server from running). Changing
an undocumented column of a system table is an even worse idea !

Razvan

.

Relevant Pages

  • Re: add column if it does not exist
    ... FROM sysobjects, ... ALTER TABLE Person ... Your solution would be to use dynamic SQL for the DDL. ...
    (comp.databases.sybase)
  • Re: Drop system table?
    ... I assume the table in question was change to xtype 'S' by hacking the ... sysobjects table. ... EXEC sp_configure 'allow',1 ... How can I get rid of it? ...
    (microsoft.public.sqlserver.server)
  • SQL Server Bug: Using scalar functions within a subquery ON Clause
    ... I've been working around this bug for a long time now, ... to report bugs on their site, I will post this here and hopefully somone will ... IF EXISTS(SELECT * FROM sysobjects WHERE name = 'Lookup_MaxSales' and xtype ...
    (microsoft.public.sqlserver.server)
  • Re: How to GET The Name of the Default?
    ... ID INT CONSTRAINT ID_DEFAULT DEFAULT 1 ... FROM sysobjects o1 JOIN syscolumns c ... ALTER TABLE test ...
    (microsoft.public.sqlserver.programming)
  • RE: looking for ways to list publication object please help
    ... select name from sysobjects ... where id not in (select objid from sysarticles) ... and xtype = 'U' ...
    (microsoft.public.sqlserver.replication)