in merge replication using sql server 2005 and sql server compact, is it possible to have triggers (or business logic) for any changes on the client side? how does a client app know an insert/update/delete has been made? also, if the article is set to download-only, can the client app also be nofied of any changes?
thanks,
bryan
Yes you can set your triggers to be FOR REPLICATION
That way they will fire when an insert,update or delete comes through replication.
Applications usually do not get notified of changes in the database by the database system. This would be possible using the CLR however normally it is the application that queries the database to see if changes have occured.
Martin
No comments:
Post a Comment