Posted by Erland Sommarskog on 09/29/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

[Back to original message]