----------------------------------------------------------- New Message on BDOTNET
----------------------------------------------------------- From: _SQL_Vinod_ Message 4 in Discussion Hi Satheesh, There are very good pointers mentioned from Srini and Kalyan. I think you are confused to how did the ADO rollback the transaction committed from SQL Sever. BTW, SQL Server didn't start the transaction on first place. ADO has the control and if you use the profiler to catch the DTC transactions then you will see that a single Transaction GUID is used to moinitor the transaction attributes of the connection. And the committing and rollback of the ADO Transaction is final ... SQL Server will just join the ADO transaction initiated. There is nothing that SQL Server maintains here. On the contrary if the component calls the SQL Server SP which has initiated a transaction and rollsback. Then we are 100% sure of the behaviour here. SQL Server will commit or rollback based on the activity at the SQL Server end. Now in this case the component call cannot do anything. HTH, Vinod Kumar MVP-SQL Server 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/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]
