Posted by Raziq Shekha on 09/29/26 11:23

Hello everyone,

SQL Server 2000. I have a database in which there are several objects
which have ansi nuls and quoted identifier turned ON. Is there a way I
can generate a script which:
(1) Can identify all objects within the database that have those two
properties turned ON and
(2) Change the properties for these objects and turn the ansi nulls and
quoted identifier OFF for those objects.

I am trying to avoid going throuh gazillions of objects and manually
doing this.

Thanks for any help.

Raziq.



*** Sent via Developersdex http://www.developersdex.com ***

• Next in forum: Re: Functions and Execution Plan
• Prev in forum: Re: Clustered index and varchar
• Thread view: Ansi Nulls and quoted identified

[Reply to this message]