disappearing data in database

We have experienced a problem recently. Where data that
was inserted/updated in the database, and verified that
they were in there, disappeared hours later. We have no
idea what is happening. The data was entered through a
Centura application or lotus notes pump job. There are
hard copies verifing that the data was there. When they
go back to alter the data, it is missing. I checked the
sql server logs and the only thing in there is the dbcc
messages and the backup messages. Nothing saying the
database was restored or any errors. I also checked the
Windows NT logs and there was nothing in there either.
Does any one know what could be happening? We are running
sql 7.0 sp4.
Thanks
DianeA suggestion might be to run a SQL Profiler Trace while
the database is in use. This will tell you exactly
what/who is doing what and when to the database.
Its something to try at least
>--Original Message--
>We have experienced a problem recently. Where data that
>was inserted/updated in the database, and verified that
>they were in there, disappeared hours later. We have no
>idea what is happening. The data was entered through a
>Centura application or lotus notes pump job. There are
>hard copies verifing that the data was there. When they
>go back to alter the data, it is missing. I checked the
>sql server logs and the only thing in there is the dbcc
>messages and the backup messages. Nothing saying the
>database was restored or any errors. I also checked the
>Windows NT logs and there was nothing in there either.
>Does any one know what could be happening? We are running
>sql 7.0 sp4.
>Thanks
>Diane
>.
>

Disable sp_MSadd_merge_history

Hi Guys,
I'm currently running a dynamic snapshot replication over a 56k modem. I
have built the snapshot and inserted the snapshot file to a USB key and
applying the snapshot from the USB Key. The problem I am encountering is
that, for every script file that is applied to the local database this sp
get fired to the Head Office server exec sp_MSadd_merge_history, is there
anyway I can disable this for an install as I can't take the server with us.
I dialup to the head office server so authentication can take place, but the
exec sp_MSadd_merge_history is slowing things down a lot.
Thanks Tim.
no, this proc is necessary for tracking information.
"Tim Ford" <tford@.in2focusnospam.com> wrote in message
news:u1mlBUdMEHA.3664@.TK2MSFTNGP10.phx.gbl...
> Hi Guys,
> I'm currently running a dynamic snapshot replication over a 56k modem. I
> have built the snapshot and inserted the snapshot file to a USB key and
> applying the snapshot from the USB Key. The problem I am encountering is
> that, for every script file that is applied to the local database this sp
> get fired to the Head Office server exec sp_MSadd_merge_history, is there
> anyway I can disable this for an install as I can't take the server with
us.
> I dialup to the head office server so authentication can take place, but
the
> exec sp_MSadd_merge_history is slowing things down a lot.
> Thanks Tim.
>