You could achieve this with a trigger + custom function. MSSQL 2005 now has this ability (though no SQL syntax applies, it's built into the ADO.NET 2.0 provider) and it's a really nice feature.
HTH Sam ------------------------------------------- We're Hiring! Seeking a passionate developer to join our team building products. Position is in the Washington D.C. metro area. If interested contact [EMAIL PROTECTED] -----Original Message----- From: Shilpa Sheoran [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 27, 2007 5:09 PM To: sqlite-users@sqlite.org Subject: [sqlite] Sqlite - LISTEN/NOTIFY All, Does sqlite implement LISTEN or NOTIFY commands? Basically if one application modifies the database will sqlite notify other interested applications about the modification? Shilpa ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------