View Full Version : database watch
Like the FileSystemWatcher class to watch file do we have any method to watch sql database table(insert,update, delete) like what trigger doing of sql.
12-29-2005, 07:57 AM
yeah, we got triggers (http://www.google.nl/search?hl=nl&q=mssql+trigger&meta=) to take care of that.
you can create a trigger for a database table, look it up in the helpfiles or on google
a trigger can fire and do some actions on an insert, update or delete in the table its defined for
That is one solution from database point. I want entire solution from .net.
12-29-2005, 09:45 AM
:o i think i didnīt read your post well enough. Sorry :o
i dont know of any databasewatcher. i think it will be a pain to build one, much different types of databases, canīt watch changes on the db-file(s) because lot of things happen in memory before the changes are written to the file(s)
i think i would rely on triggers to watch for specific changes
Powered by vBulletin® Version 4.2.2 Copyright © 2016 vBulletin Solutions, Inc. All rights reserved.