Hi All,
Good Morning.
I have created a Trigger on a particular Table that after insert it will create a copy to another table which is located to a remote server.
The command goes like this.
Create Trigger RemoteInsert on Test_Table After Insert
as
Begin
Insert Into OpenQuery(RemoteServer1,
'Select Col1, Col2, Col3 from Server..Remote_Table')
Select
NewCol1,
NewCol2,
NewCol3
from inserted
End
When I insert the data via C# Desktop Application, I receive and error that
"Error Saving Record: Remote Access is not Supported Transaction Isolated level 'SNAPSHOT'.
I have tried to Turn On the "READ_COMMITTED_SNAPSHOT" but it doesnt work.
As much as possible I want to use the trigger so that I can retrieve the data in real time, but if there are no other way I think I will have to use a SQL Job to solve the problem.
Kindly advise if there are some ways to fix the Isolation Level Snapshot problem
Thank you 
Transaction Isolated SnapShot Fix
Posted - 2015-04-20 : 02:14:19
