freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Re: Polling tables?

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

Polling tables?, James Cameron, 09/04/2002
- <Possible follow-up(s)>
- Re: Polling tables?, Brian Bruns, 09/04/2002
- Re: Polling tables?, Bob Kline, 09/04/2002
- Re: Polling tables?, James K. Lowden, 09/05/2002
- RE: Polling tables?, Varley, David(CBorn at Alcoa), 09/05/2002