> I have following problem, one of our SQL2000 databases is being feed every
> night from external CRM system by mean of ODBC DSN data source, most of the
> time is working fine but sometimes we have an instance there not all of the
> data is pulled over, I can go then and add missing part manually (it's not a
> lot) but would like to know why this is happening, most I’m concern happened
> just this week, I go notified that expected data is missing, we verified that
> it exist in the system that is pulling from, added manually (here is the
> strange part) day or two later 4 rows added manually disappeared, I only can
> see data that was pulled as automatic feed, this is only one way feed (sql
> does not feed the other one) so this makes me think that scheduled feed is
> overwriting what I did manually (although it never happened before as fas as
> I know), where and how can I get detailed log of what this feed actually does
> (besides setting profiler), of course other party claims their piece of code
> is working ok... some additional info, database was created as simple mode,
> weekly we run integrity check and optimization, daily full backup... I doubt
> sql jobes does this damage.