>>1. How can i set the sql servers environment when i make the connection
>> for ex. if i want to set date format or lets say quoted_identifier off/on
>> i can set it b4 executing my sqlbut it would be session specific for that
>> query only, I want to set it throughout my connection.
>> is it possible ??

>I think that I have read something like you need to execute the command on the >connection, ie:

>connection.open
>connection.execute "Set nocount on"

I think this command would not be available through out my connection is open.
i got one sol. for that which is sys stored procedure
sp_dboption
which allows me to set/reset

>Always give the date as yyyy/mm/dd to SQL and there won't be ambigous dates.
yeah Eric perfect ! thanks