User connection idle too long.

[kmsam2]

When user login into MS SQL Server, a connection will be created.
If the user close the browser without logoff, that connection still remain there, anyway to prevent this, or I need to write a script to kill it ?

Sam.

 

[ks2000]

hi
when ever he closes the browser automatically connection will also application, but you have see one thing ,
if there are any updations or insertions happening from
the browser , automatically roll back process also starts when ever he closes the application.

Good Luck
Gopala Krishna Kakani