Connection options

11 Aug 2006 3:01 PM

simonZ

When I create some stored procedure in enterprise manager and then edit the
syntax in sql query analyzer, I always get the folloewing 2 lines in front
of procedure:

SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS OFF
GO

ALTER PROCEDURE .....

Why?

Because this 2 options are set to OFF, my indexed view doesn't work.

How can I set that the syntaks would look like this:
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO

ALTER PROCEDURE .....

I have connection settings setted to ON and query analyzer settings setted
to ON, but nothing helps?

Regards,Simon

14 Aug 2006 10:38 AM

Tibor Karaszi

First, I suggest that you work from script files, and not from the database. That allow you to have
anything you like in that script file,and when you open the file, you know what you get and are not
left to the mercy of how a certain tool handles this.

Anyhow, if you in the edit window set the setting as you wish to have then, execute the create
statement, then QA will generate that setting next time you Edit the procedure.

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/

Show quote

"simonZ" <simon.zu***@studio-moderna.com> wrote in message
news:Ogf%23OE4vGHA.4972@TK2MSFTNGP05.phx.gbl...
> When I create some stored procedure in enterprise manager and then edit the syntax in sql query
> analyzer, I always get the folloewing 2 lines in front of procedure:
>
> SET QUOTED_IDENTIFIER OFF
> GO
> SET ANSI_NULLS OFF
> GO
>
> ALTER PROCEDURE .....
>
>
> Why?
>
> Because this 2 options are set to OFF, my indexed view doesn't work.
>
> How can I set that the syntaks would look like this:
> SET QUOTED_IDENTIFIER ON
> GO
> SET ANSI_NULLS ON
> GO
>
> ALTER PROCEDURE .....
>
> I have connection settings setted to ON and query analyzer settings setted to ON, but nothing
> helps?
>
> Regards,Simon
>