Hi all,

I am using a program which performs ADO connection which by the mean of
stored procedures, performs distirbuted transaction between 2 SQL Server
instances.

Recently this program failed due to several access violation, thus closing
unexpectedly any opened connection on the local sql server instance to which
it is connected (i received error "8500 Commit of internal transaction
failed").

Can anyone confirm that closing connection this way while performing
distributed transaction CAN result in a failure of the 2 Phase Commit process
leaving transaction commited on one side and uncommited on the other side ?

[ database_name . [ schema_name ] . | schema_name . ] table_name
SQL question
Function results
Passing a parameter as list in a Stored procedure
select based on containing only certain characters