FreeTDS Development Group

[Bob Kline <bkline AT rksystems.com>]

On Wed, 4 Sep 2002, Brian Bruns wrote:

> Not that I'm aware of.  With Sybase you may be able to use replication
> server to monitor the transaction log and deliver the transaction to a
> bogus server using either OpenServer or libtdssrv.  This is all rather
> theoretical at the moment though since I don't think it's ever been done
> ;-)
>
> the other options would be a pass thru server that the client connected to
> (ala tdspool) before being passed to the real server to intercept the
> call, or updating the table via a stored procedure that could then do some
> sort of RPC thing yet to be worked out.
>
> We use Sybase extended stored procedures (C stored procs with system
> 11.5 and above) to do the above type situation.  Not sure if MS has
> anything resembling that.

Sure.  That's what triggers are for.

>
> Brian
>
> On 5 Sep 2002, James Cameron wrote:
>
> > FreeTDS user query ... is there a way to have the SQL server tell me
> > when a table or row has been modified?
> >
> > At the moment, I place the SELECT in a loop, with a few seconds of
> > sleep(), but that's a bogosity ... I hate polling; it creates load and
> > still has a response delay.  Is there a way I can wait for an UPDATE or
> > INSERT by another connection on a particular table?
> >
> > SELECT @@VERSION
> >
> > Microsoft SQL Server 7.00 - 7.00.842 (Intel X86) Mar 2 2000 06:49:37
> > Copyright (c) 1988-1998 Microsoft Corporation Enterprise Edition on
> > Windows NT 4.0 (Build 1381: Service Pack 6)
> >
> >
>
>
> ---
> You are currently subscribed to freetds as: [bkline AT rksystems.com]
> To unsubscribe, forward this message to $subst('Email.Unsub')
>

-- 
Bob Kline
mailto:bkline AT rksystems.com
http://www.rksystems.com