Hi,
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 ??

2. can anyone suggest how to handle date insertion in sql server ?????
for ex. if date format at sql is mdy and i waana insert 2 mar 2002.
now my application accept dd/mm/yy so when in passes '02/03/2002' the date
actually get inserted is 3rd feb.

or do i 've to execute set dateformat dmy b4 execution of my sql ???

thanks