----------------------------------------------------------- New Message on BDOTNET
----------------------------------------------------------- From: RajDotNet Message 2 in Discussion Hi All, We have a deployment environment where in multiple threads access same database resources (queries and Stored Procedure). These threads will work on independent records and number of threads will vary based on configuration. If more than two threads trying to access single stored proc (some time queries) database is raising a lock exception. I would like to know from database perspective how to reduce the chances of occcurence of this problem and is there any constraint to be set to restrict number of threads accessing same database resources. Thanks in advance, RajDotNet ----------------------------------------------------------- To stop getting this e-mail, or change how often it arrives, go to your E-mail Settings. http://groups.msn.com/bdotnet/_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]
