All,

I'm trying to write some code that will detect changes in a database
table (like a record value modified) in SQL Server 2000.

I've tried to pull all records and place them in a dataset and merge
against existing records every few seconds but the DS Merge does not
seem to work.

Any suggestions on how to perform this operation without going cell by
cell? Are there any built in .NET funtions for this?

Dave,

Add triggers to the SQL Server tables to log each change. Then monitor the
log and update the Dataset intelligently.

Depending on your data needs, switching to a real-time database such was
www.polyhedra.com might also be an alternative.

Hope this helps
Ad.

<(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> All,
>
> I'm trying to write some code that will detect changes in a database
> table (like a record value modified) in SQL Server 2000.
>
> I've tried to pull all records and place them in a dataset and merge
> against existing records every few seconds but the DS Merge does not
> seem to work.
>
> Any suggestions on how to perform this operation without going cell by
> cell? Are there any built in .NET funtions for this?
>