SEET Options For SQL 2005 Connection

Hi,,

when I open a connection to SQL Server 2005 (c#, VB.NET 2005, SQL Native Client) these setting are set (can see it in Profiler):

-- network protocol: TCP/IP
set quoted_identifier on
set arithabort off
set numeric_roundabort off
set ansi_warnings on
set ansi_padding on
set ansi_nulls on
set concat_null_yields_null on
set cursor_close_on_commit off
set implicit_transactions off
set language us_english
set dateformat mdy
set datefirst 7
set transaction isolation level read committed

I would like ARITHABORT to be ON. Have tryied to set it as a defaul in my database, but still the connection has OFF at this setting.

How can I force my C# code to set this option to ON during connection opening?


Thanks,
Przemo