Session settings for SQL Server

  • Thread starter Thread starter Paul Hatcher
  • Start date Start date
P

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
 
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
 
Thanks Wayne

Paul

Wayne Snyder said:
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
Click to expand...
 
Back
Top