A colleague was telling me the other day that in Sql Server 2005 there is a
special type of query you can do, whereby it runs in the background and
brings back results automatically, whenever they change.  He referred to it
as something called a "live" query, but I'm not sure that's correct
terminology.

In theory you could run such a query, and sit back and watch the results
change in Query Analyser (or wherever).  For example if you were monitoring
total sales, you could literally run the query and it would "auto update" in
front of your eyes, as sales increased.

Then you could theoretically write a client application with, say, a grid
which was bound to the "live query" and updated itself magically.

One could write a client app which polled the database every 2 seconds or
whatever, but that's not as efficient as picking up data *only* when it
changes.

Obviously it depends on the client limitations, but has anyone heard of such
a thing in SQL 2005?

Thanks,
Owen

Query Notification.

Query Notifications in ADO.NET 2.0
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnvs05/html/querynotification.asp

David

Show quote Hide quote Sounds about right, thanks very much indeed. !

ORDER BY DATETIME field BUG?
Subquery performance concern
A query runs 1 times slower from a .NET application the from Query Analizer
Help with varchar to date
schedule dts at a remote server