Session settings for SQL Server

[Paul Hatcher]

Does anyone have an example of how to set the session settings on a SQL
Server ADO.NET connection string - I need to force the values of ANSI NULLs
and Quoted Identifiers.

They are set at the database level, but the ADO.NET seems to be overriding
them.

Regards

Paul

 

[Wayne Snyder]

I don't know that you can set these in the connection string(maybe you can),
but they can be set in sp_configure 'user options', and the set statment.

Be aware that if you change them from the default setting of ON, you may not
be able to share SP plans, which results in more memory consumption by SPs,
and more recompile time..

--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)

I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org

 

[Paul Hatcher]

Thanks Wayne

Paul

I don't know that you can set these in the connection string(maybe you can),
but they can be set in sp_configure 'user options', and the set statment.

Be aware that if you change them from the default setting of ON, you may not
be able to share SP plans, which results in more memory consumption by SPs,
and more recompile time..

--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)

I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org