Data change event

Let's say I want to have a Web page that will be showing live data change in
a SQL table? Is it possible to have on SQL side some kind of listener that
will propogate changes to the Web page?
ThanksMarkgoldin wrote:
> Let's say I want to have a Web page that will be showing live data change
in
> a SQL table? Is it possible to have on SQL side some kind of listener that
> will propogate changes to the Web page?
I've always done the opposite, have the Web page query the database
whenever it needs to be refreshed. Even if you build a component with
ActiveX or Java it would still require the client to continually connect
to the data source to determine if there were changes. If you aren't
particular about how it works then just have the Web page refresh itself
on a regular basis, it's alot easier.
gorf|||If you are using SQL Server 2005, then lookup Query Notification in BOL. If
you are using an earlier version, then, as far as I know, you have to have
your application poll the database to look for changes.
"Markgoldin" <Markgoldin@.discussions.microsoft.com> wrote in message
news:D9064F07-0DB3-4687-B562-DF800DD8DA64@.microsoft.com...
> Let's say I want to have a Web page that will be showing live data change
> in
> a SQL table? Is it possible to have on SQL side some kind of listener that
> will propogate changes to the Web page?
> Thanks