Let it be said from the beginning, that I am in no way an expert on SQL (But I am damn good when it comes to Navision 
However, I have a HUGE problem. I am running Navision 3.60 on SQL - Let’s call that server ‘LAKE’. it is MSSQL 2000 Then, I have a webservices server, recieving data on annother server - Let’s call that server ISLAND. - MSSQL 2000 Now - I have created a view on LAKE, that are retrieving data from ISLAND. I have a Table in Navision, that uses the view (Table (View) and field names are alike). When building a Form in Navision, I can see the data - No problem. BUT, when I try to modify, delete or instert records I get an error message: —8<-----8<-----8<-----8<-----8<-----8<-----8<-----8<-----8<-----8<-----8<-----8<-- The following SQL Server error(s) occurred while accessing the table: 7395,“42000”,[Microsoft],[ODBC SQL Server Driver][SQL Server]Unable to start a nested transaction for OLE DB providor ‘SQLOLEDB’. A nested trasaction was required because the XACT_ABORT option was set to OFF. 7312,“01000”,[Microsoft][ODBC SQL Server Driver][SQL Server][OLE/DB providor returned message: Cannot start more transactions on this session.] —8<-----8<-----8<-----8<-----8<-----8<-----8<-----8<-----8<-----8<-----8<-----8<-- What the hell does THAT mean. And - Am I the only guy “Out here” that are in need of modifying SQL records from Navision, or am I just a budhead???
OK - I figured it out (thanks to one of my colleagues) First off, the property LinkedInTransaction must be NO in Navision. Then, you MUST have a field in the SQL Table that are names timestamp and the datatype timestamp. And that was all. wohooo