Hello,

I've been working on an application for my company, and implementing solutions to small problems along the way has caused me quite a bit of trouble.

I'm looking for a quick & dirty way to monitor a MSSQL database for changes. I need to take an image of this database table & at any later, arbitrary point in time, take another image & compare to determine the differences.

I know I could do this with the MSSQL event notification services, but this seems a bit too complex for the more simple application I'm creating.

What I was thinking about doing was creating a serializable object & a serializable strongly typed collection of this object & saving this to disk to store the current image of the db, then, using a timer, every 5 minutes querying the db for a new copy of this info, then comparing the two to see what's in the new db that wasn't in the original.

Can anyone think of a smarter or quicker way to implement this? Any comments would be greatly appreciated!

Thanks!!

-corteplaneta