----------------------------------------------------------- New Message on MumbaiUserGroup
----------------------------------------------------------- From: VinodK Message 2 in Discussion Hi, Its really strange by the actual problem description. But I wanted to clarify on some of the observations I can make. I didn't understand when you mean "temporary table" ... Is it a SQL Server Temp table or something else... Please clarify on that point ... Well it is to be understood that when you accessed the same record with ISQLW there was a time out. This clearly indicates that the SQL Server has put an lock on the resource you are trying to access. And the VB app is surely puting a Exclusive lock on the resource under microscope. I've not worked with crystal reports extensively. But my basic question out here is "what is the transaction Isolation level that srystal reports uses?". If this is going to be READ UNCOMMITED then this can fetch you phantom records. And by any chance are there any hints placed in the query posted to crystal reports? Like "NOLOCK" hints ... If they are present then you can get uncommited records. These are some of the practical scenarios you can encounter such a behaviour. But I am sure that even when this happens you system cannot freeze. BTW how do you update all the 100 records. If its from a SP then place a SET NOCOUNT ON ... In such cases there is no extra ODBC round trips to notify the number of records affected ... HTH, Vinod Kumar Microsoft India Community Star www.extremeexperts.com ----------------------------------------------------------- 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]
