> when creating a stored procedure or a user defined function using
> enterprise manager, how to determine the settings for the
> connection under which the create sql is being executed ....
>
> i'm talking about settings such as ANSI_NULLS
>
> enterprise manager : <database name> : properties : options
>
> provides a variety of settings for each database -- do these
> refer settings refer to the connection under which enterprise
> manager executes t-sql ?

"lindawie" <lindawie@my-deja.com> wrote in message news:%23IqY26$rDHA.2340@TK2MSFTNGP12.phx.gbl...
> John,
>
> > when creating a stored procedure or a user defined function using
> > enterprise manager, how to determine the settings for the
> > connection under which the create sql is being executed ....
> >
> > i'm talking about settings such as ANSI_NULLS
> >
> > enterprise manager : <database name> : properties : options
> >
> > provides a variety of settings for each database -- do these
> > refer settings refer to the connection under which enterprise
> > manager executes t-sql ?
>
> Look at Server Properties, Connections tab to view and change the
> settings currently in effect.
>
> You can determine which settings were in effect for ANSI nulls and
> quoted identifiers when an object was created by scripting out the
> object and then looking at the script.
>
> Linda
>
>

> Wouldn't this change the default setting for all connections (not
> only EM)? Might cause problem for other users/applications :-).

> "lindawie" <lindawie@my-deja.com> wrote in message
> news:%23IqY26$rDHA.2340@TK2MSFTNGP12.phx.gbl...
>> John,
>>
>>> when creating a stored procedure or a user defined function
>>> using enterprise manager, how to determine the settings for the
>>> connection under which the create sql is being executed ....
>>>
>>> i'm talking about settings such as ANSI_NULLS
>>>
>>> enterprise manager : <database name> : properties : options
>>>
>>> provides a variety of settings for each database -- do these
>>> refer settings refer to the connection under which enterprise
>>> manager executes t-sql ?
>>
>> Look at Server Properties, Connections tab to view and change the
>> settings currently in effect.
>>
>> You can determine which settings were in effect for ANSI nulls
>> and quoted identifiers when an object was created by scripting
>> out the object and then looking at the script.
>>
>> Linda