----------------------------------------------------------- New Message on MumbaiUserGroup
----------------------------------------------------------- From: PKSPMR Message 1 in Discussion Hi All, I have a requirement to run SP (SQL server 2005) that takes around 1 hr to finish. So, I decided to use asynchronous approach. with ado.net 2.0, we have asynchronous property set to true in connectionstring, we can achieve this. It is working fine. Once I run asp.net 2.0 app, execute SP, that gets run on different thread freeing up UI for user to perform other jobs. My concern is, when SP finishes its job after 1 hour, when I see SQL server 2005 activity monitor, connection is not killed or cleared. It is still alive in sleep status. I don't want this to happen. I want connection to be cleared after the job is done. I used BeginExecuteNonQuery because I don't want any results back. This method doesn't have commandbehaviour.closeconnection as parameter which is there for BeginExecuteReader. I even tried Peter (eggheadcafe.com)'s article on this http://www.eggheadcafe.com/tutorials/aspnet/aa5ff306-16a1-4014-a51d-6ffde0894a0d/aspnet-request-logging-w.aspx It is working but connection is timing out. If I set command object's timeout then working fine. Anyone have any other approaches or ideas in handling this. I appreciate your response. Thanks, PK ----------------------------------------------------------- To stop getting this e-mail, or change how often it arrives, go to your E-mail Settings. http://groups.msn.com/MumbaiUserGroup/_emailsettings.msnw Need help? If you've forgotten your password, please go to Passport Member Services. http://groups.msn.com/_passportredir.msnw?ppmprop=help For other questions or feedback, go to our Contact Us page. http://groups.msn.com/contact If you do not want to receive future e-mail from this MSN group, or if you received this message by mistake, please click the "Remove" link below. On the pre-addressed e-mail message that opens, simply click "Send". Your e-mail address will be deleted from this group's mailing list. mailto:[EMAIL PROTECTED]
