Posted by Erland Sommarskog on 09/15/06 21:34

(betbubble@gmail.com) writes:
> These SPs were generated using the Query Analyzer, ANSI_NULLS and
> QUTOED_IDENTIFIERS are OFF. I turned them ON manually. Is there
> something wrong with my Query Analyzer settings?

You can change the connection settings under Tools->Options->Cononection
Properties. The default settings is that all settings for indexed views
are on, but you might have changed that at some point.

Also, if the SP was originally created by EM, and you scripted it from
QA, QA will include the original settings in the script, so you will
actively have to change them - or just remove them-


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

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

• Next in forum: Re: sql server i/o bottle neck ?
• Prev in forum: Re: looking to tune query...
• Thread view: Re: Can I avoid temp tables, etc.

[Reply to this message]