Posted by Erland Sommarskog on 10/01/23 11:23

Razvan Socol (rsocol@gmail.com) writes:
> Yes, I have tested it (to turn ON those properties) and found no
> side-effects.

Hm, if you have a procedure that reads:

CREATE PROCEDURE ill_will AS
PRINT "Hej!"

and it was loaded with QUOTED_IDENTIFIER off, and you change it to ON,
I bet you see have side effects!


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp

• Next in forum: Re: Ansi Nulls and quoted identified
• Prev in forum: Re: 256 table limit for partitioned views
• Thread view: Re: Ansi Nulls and quoted identified

[Reply to this message]