While doing year end inventory we have come across the following errors and the software closes.
---------------- Store Operations Business Rules Database connection lost, application will be closed Error #-214746759 Connection Failure (Source:Microsoft OLE DB Provider for SQL Server) (Sql State: 08501) (NativeError:0) No Help file available
SELECT GETDATE() AS CurrentDateTime
------------
Store Operations Business Rules the index entry for row ID was not found in index ID 3, of table 453576654, in database 'Gallery_live'. (Source: Microsoft OLE DB Provider for SQL Server) (SQL State: HY000) (NativeError: 8646) No Help file available UPDATE Item SET LastCounter = CASE WHEN CountTime IS NULL THEN Last Counted ELSE CounTime END FROM ##PhysicalInventoryScratch_0_1 INNER JOIN Item.ID = ##PhysicalInventroyScratch_0_1.ItemID
----------------
The computer is a IBM 4910-32m VIA Nehemiah chip @1.19ghz
380mbHistory... The system worked fine last year for year end reconciliation. I added a different network card because the built in one was not reliable.
-----------------
Any ideas on solving this problem would be great.
Submitted via EggHeadCafe - Software Developer Portal of Choice SQL Server - Insert Record And Get New ID