Re: Database Corruption
From: Mary Bray (no_at_spam.com)
Date: 09/30/04
- Next message: pmasters: "User Permissions"
- Previous message: Bil: "Re: Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection."
- In reply to: jack: "Database Corruption"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Thu, 30 Sep 2004 18:12:31 +1000
I'd be looking at the code that is doing the saving and possibly running a
trace to see if the error can be trapped. I doubt there is a problem with
the tables, but you can run DBCC CheckTable to be sure (instructions in SQL
Books On Line).
You may have a transaction not being completed and thus the line is not
saved...
"jack" <jackolantern25@hotmail.com> wrote in message
news:uPrrU4rpEHA.2104@TK2MSFTNGP10.phx.gbl...
> Hello,
> I have a problem with database corruption. In the database there several
> thousand parts and a few hundred partlists, the partlists are becoming
> corrupt when closed after editing, not all of them, it happens maybe 1 in
> 100 list edits. One line disappears from the list and then the client
> cannot
> call the list anymore, I have to add the line back in manually.
>
> I have looked in all the windows logbooks and there are no error messages,
> the only SQL messages are that the TRN file has been made each hour.
>
> How can I find out what is causing the coruption?
>
> Thanks
> Jack
>
>
- Next message: pmasters: "User Permissions"
- Previous message: Bil: "Re: Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection."
- In reply to: jack: "Database Corruption"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
|
