"Live" queries in sql 2005 ?

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"Owen" <spam@.spam.com> wrote in message
news:lZOdnfeFS9oemgbZnZ2dnUVZ8smdnZ2d@.pi
pex.net...
>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.
>
Query Notification.
Query Notifications in ADO.NET 2.0
http://msdn.microsoft.com/library/d...otification.asp
David|||"David Browne" <davidbaxterbrowne no potted meat@.hotmail.com> wrote in
message news:uaX3ADllGHA.3740@.TK2MSFTNGP02.phx.gbl...
> "Owen" <spam@.spam.com> wrote in message
> news:lZOdnfeFS9oemgbZnZ2dnUVZ8smdnZ2d@.pi
pex.net...
> Query Notification.
> Query Notifications in ADO.NET 2.0
> http://msdn.microsoft.com/library/d...otification.asp
> David
Sounds about right, thanks very much indeed. !
Owen.
http://www.riptheuglybluevoidfromyourhead.com

"Ghost" database for testing purposes. Copying all tables, views,

hello.
I have a LIVE database. At the same time i am still working on my app. It's
a .Net application. Now, i need to constantly makes changes in both tables.
Not to the data, but to the design. Some fields might be added, some deleted,
new views, new sp.
My question is... How can i automatically update the Live database with any
change in the development database. I would rather make the changes in the
Live database to assure no data loss occur, but i want those changes to be
"replicated" back to my development. is there any system's stored proc that
would help me do that?
Thank you.Automating it is asking for trouble...in case you get someting wrong.
If you insist, use Red Gate SQL Compare to reveal differences between the
two for you and generate a script to run against the live db AFTER you BACK
IT UP :)
--
Kevin3NF
SQL Server dude
You want fries with that?
http://kevin3nf.blogspot.com/
I only check the newsgroups during work hours, M-F.
Hit my blog and the contact links if necessary...I may be available.
"Jose Fernandez" <Jose Fernandez@.discussions.microsoft.com> wrote in message
news:0997C63F-78D0-4618-8D07-5A9DE461107A@.microsoft.com...
> hello.
> I have a LIVE database. At the same time i am still working on my app.
> It's
> a .Net application. Now, i need to constantly makes changes in both
> tables.
> Not to the data, but to the design. Some fields might be added, some
> deleted,
> new views, new sp.
> My question is... How can i automatically update the Live database with
> any
> change in the development database. I would rather make the changes in the
> Live database to assure no data loss occur, but i want those changes to be
> "replicated" back to my development. is there any system's stored proc
> that
> would help me do that?
> Thank you.|||=?Utf-8?B?Sm9zZSBGZXJuYW5kZXo=?= <Jose
Fernandez@.discussions.microsoft.com> wrote in
news:0997C63F-78D0-4618-8D07-5A9DE461107A@.microsoft.com:
> hello.
> I have a LIVE database. At the same time i am still working on my app.
> My question is... How can i automatically update the Live database
> with any change in the development database. I would rather make the
Ditto. www.red-gate.com. It is awesome in a dev/test/prod environment.
Costs about $400.

"Ghost" database for testing purposes. Copying all tables, views,

hello.
I have a LIVE database. At the same time i am still working on my app. It's
a .Net application. Now, i need to constantly makes changes in both tables.
Not to the data, but to the design. Some fields might be added, some deleted,
new views, new sp.
My question is... How can i automatically update the Live database with any
change in the development database. I would rather make the changes in the
Live database to assure no data loss occur, but i want those changes to be
"replicated" back to my development. is there any system's stored proc that
would help me do that?
Thank you.
Automating it is asking for trouble...in case you get someting wrong.
If you insist, use Red Gate SQL Compare to reveal differences between the
two for you and generate a script to run against the live db AFTER you BACK
IT UP
Kevin3NF
SQL Server dude
You want fries with that?
http://kevin3nf.blogspot.com/
I only check the newsgroups during work hours, M-F.
Hit my blog and the contact links if necessary...I may be available.
"Jose Fernandez" <Jose Fernandez@.discussions.microsoft.com> wrote in message
news:0997C63F-78D0-4618-8D07-5A9DE461107A@.microsoft.com...
> hello.
> I have a LIVE database. At the same time i am still working on my app.
> It's
> a .Net application. Now, i need to constantly makes changes in both
> tables.
> Not to the data, but to the design. Some fields might be added, some
> deleted,
> new views, new sp.
> My question is... How can i automatically update the Live database with
> any
> change in the development database. I would rather make the changes in the
> Live database to assure no data loss occur, but i want those changes to be
> "replicated" back to my development. is there any system's stored proc
> that
> would help me do that?
> Thank you.
|||=?Utf-8?B?Sm9zZSBGZXJuYW5kZXo=?= <Jose
Fernandez@.discussions.microsoft.com> wrote in
news:0997C63F-78D0-4618-8D07-5A9DE461107A@.microsoft.com:

> hello.
> I have a LIVE database. At the same time i am still working on my app.
> My question is... How can i automatically update the Live database
> with any change in the development database. I would rather make the
Ditto. www.red-gate.com. It is awesome in a dev/test/prod environment.
Costs about $400.