FreeTDS Development Group

[Brian Bruns <camber AT ais.org>]

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.

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)
> 
>