Data Lost

Excuse me if my redaction is bad, but I don't speak english very well.
My Question is:
I have a SQL DataBase in which every day I save a lot of records.
I'm sured that the records are in the Database because I can see them.
I made queries in DB using a Windows application but next day I query again
and I can't see the records.
There are no proccess like stored procedures that delete the records; even
the application doesn't have an option to delete them.
First time, I thougt the reason was the DataBase Server wasn't shut down
correctly. But this time Server wasn't shut down.
I really need help because it's very stranger. can somebody help me to find
the phantom?
Thanks!!!Thats an odd one.
What I would sugest is you run a trace on your database to see who or what
is removing the data.
The thing is it could be justabout anything or anyone.
Something you could do in the meanwhile is to denign delete permission on
the table execpt for DBA's
Peter
"Edward" wrote:
> Excuse me if my redaction is bad, but I don't speak english very well.
> My Question is:
> I have a SQL DataBase in which every day I save a lot of records.
> I'm sured that the records are in the Database because I can see them.
> I made queries in DB using a Windows application but next day I query again
> and I can't see the records.
> There are no proccess like stored procedures that delete the records; even
> the application doesn't have an option to delete them.
> First time, I thougt the reason was the DataBase Server wasn't shut down
> correctly. But this time Server wasn't shut down.
> I really need help because it's very stranger. can somebody help me to find
> the phantom?
> Thanks!!!|||I will do it, but I'm sure that nothing is deleting the records, this is a
thecnical problem.
Thanks
"Peter Nolan" wrote:
> Thats an odd one.
> What I would sugest is you run a trace on your database to see who or what
> is removing the data.
> The thing is it could be justabout anything or anyone.
> Something you could do in the meanwhile is to denign delete permission on
> the table execpt for DBA's
> Peter
> "Edward" wrote:
> > Excuse me if my redaction is bad, but I don't speak english very well.
> >
> > My Question is:
> > I have a SQL DataBase in which every day I save a lot of records.
> > I'm sured that the records are in the Database because I can see them.
> > I made queries in DB using a Windows application but next day I query again
> > and I can't see the records.
> > There are no proccess like stored procedures that delete the records; even
> > the application doesn't have an option to delete them.
> > First time, I thougt the reason was the DataBase Server wasn't shut down
> > correctly. But this time Server wasn't shut down.
> > I really need help because it's very stranger. can somebody help me to find
> > the phantom?
> >
> > Thanks!!!|||Hi Edward
Are you inserting the records into a temporary table by any chance?
Can you please send the table structure and the query that you are using to
view the data. Also please check in the database if data is present
thanks and regards
Chandra
"Edward" wrote:
> Excuse me if my redaction is bad, but I don't speak english very well.
> My Question is:
> I have a SQL DataBase in which every day I save a lot of records.
> I'm sured that the records are in the Database because I can see them.
> I made queries in DB using a Windows application but next day I query again
> and I can't see the records.
> There are no proccess like stored procedures that delete the records; even
> the application doesn't have an option to delete them.
> First time, I thougt the reason was the DataBase Server wasn't shut down
> correctly. But this time Server wasn't shut down.
> I really need help because it's very stranger. can somebody help me to find
> the phantom?
> Thanks!!!|||Hi chandra!!!
If I send you the inserts and updates made in the tables I'll send many
statements, because they are many tables involved in a transaction that is
handled by the same stored procedure, I think that the problem is cause at
transaction level, but I do not understand either, because if the problem
were of this type, the rest of clients applications that works with the
database would be locked.
another thing is happened to me ¿ The backup log that is made over the
database
every day may cause that the last transactions commited will be losted?
"Chandra" wrote:
> Hi Edward
> Are you inserting the records into a temporary table by any chance?
> Can you please send the table structure and the query that you are using to
> view the data. Also please check in the database if data is present
> thanks and regards
> Chandra