Skip to Content.
Sympa Menu

freetds - Re: Polling tables?

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "James K. Lowden" <jklowden AT schemamania.org>
  • To: "TDS Development Group" <freetds AT franklin.metalab.unc.edu>
  • Cc: james.cameron AT hp.com
  • Subject: Re: Polling tables?
  • Date: Thu, 5 Sep 2002 08:41:24 -0400


On 05 Sep 2002 09:30:50 +1000, James Cameron <james.cameron AT hp.com> wrote:

> FreeTDS user query ... is there a way to have the SQL server tell me
> when a table or row has been modified?

G'day James,

Set up a trigger on the table to do a Raiserror (state 1 severity 1) for a
message number of your choosing. You'll want to register the message
first; sp_addmessage IIRC.

Then craft a message handler to look for your message number.

Triggers fire once per SQL statement; if you want per-row notification
ouch you'll have more work to do.

Regards,

--jkl




Archive powered by MHonArc 2.6.24.

Top of Page