Update Native Statistics job fails with the following error:
'ACTIVE_TRANSACTION'. [SQLSTATE 42000] (Error 9002) RegQueryValueEx() returned error 2, 'The system cannot find the file specified.' [SQLSTATE 01000] (Error 22001). The step failed.
May also result in the transaction log for tempdb to fill.
Job failure message: The transaction log for database 'tempdb' is full due to 'ACTIVE_TRANSACTION'. [SQLSTATE 42000] (Error 9002) RegQueryValueEx() returned error 2, 'The system cannot find the file specified.' [SQLSTATE 01000] (Error 22001). The step failed.
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center