...

View Full Version : database watch



ebco
12-29-2005, 08:01 AM
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.

Roelf
12-29-2005, 08: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

ebco
12-29-2005, 09:48 AM
That is one solution from database point. I want entire solution from .net.

:p

Roelf
12-29-2005, 10: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



EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum