title: Querying in linked server problem - Remote access is not supported for transaction isolation level "SNAPSHSHOT"
body: <p>My problem is that I'm joining table from the current SQL Server and Linked Server database table in my query. </p>
  
  <p>I tried to query it inside MS SQL Server and it was okay no problems with it. But when I tried it with C# it produced an error. I'm afraid to try other solutions since it is a crucial time for me to mess up. </p>
  
  <p>The Linked Server database is a standard database in Microsoft Dynamics AX, and I guess I should not alter it just to make my task work.</p>
  
  <p>I just want to double check this with all of you guys, I'm seeking for your suggestions. Do you think that SET ALLOW_SNAPSHOT_ISOLATION ON is the best solution?</p>
  
  <p><a href="https://imgur.com/a/uJBmunz" rel="nofollow noreferrer">https://imgur.com/a/uJBmunz</a></p>
  
  <p>My expected result is just to execute my query with no error.</p>