Hi all, Sometime we face an error in SQL Server while performing transaction in Navision. ERROR - (Error 9002) The following SQL Server Error or errors occured when accessing the "Table Name" table: 9002,"42000",[Microsoft][ODBC SQL Server Driver][SQL Server] The trasaction log for database 'Database name' is full. To find out why space in the log cannot be reused, see the log_reuse_Wait_desc column in sys.database. SQL: Update "database name"."dbo"."Table Name" with (RepeatTableRead) set something where query. Reason For Error- The error is due to space avilability in the disk where Log file reside. Resoultion - There are multiple options for the resoultion of the same, choose one that best suite you- 1) Backing up the Log. 2) Freeing Disk Space. 3) Moving the Log File to a Different Disk 4) Increasing the size of a log file. 5) Adding a log file on a different disk. 6) Completing or killing a long-
What's new and solution to problems related to Microsoft Dynamics NAV and Microsoft Dynamics 365 Business Central.