471,605 Members | 1,503 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,605 software developers and data experts.

Data Changed Event ?

Hello,

I'm using SQL server 2000.
I want to permanently have a deconnected dataset taken with a select command
like SELECT* FROM table WHERE myActiveField=True

When The Field "myActiveField" is chnaged by another software, I want to
refresh my dataset.
Is it possible to do that ?

I think with sqlserver2005 it's possible, but with 2000 ?

Thx
Jan 27 '06 #1
2 2049
I don't remember how to do it, but what I do remember from the demo's I've
seen is that is possible with 2005 and 2000 using .net 2.0. You implement
both the same way.

With 2005, it is supported by SQL natively. With 2000 the 2.0 frame work
sets up a polling mechanism and will poll your database to see when data has
changed.

Thanks
Wayne

"Geoffrey" <AE**************@dufour.be> wrote in message
news:ON**************@tk2msftngp13.phx.gbl...
Hello,

I'm using SQL server 2000.
I want to permanently have a deconnected dataset taken with a select
command
like SELECT* FROM table WHERE myActiveField=True

When The Field "myActiveField" is chnaged by another software, I want to
refresh my dataset.
Is it possible to do that ?

I think with sqlserver2005 it's possible, but with 2000 ?

Thx

Jan 27 '06 #2
I've never tried it, but the scuttlebut I've heard here is that it's
incredibly resource intensive, and you're better off having your app
periodically poll the database for changes.

As I said, though, I've never tried it, so I don't stand by this
advice. :)

Jan 27 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

4 posts views Thread by JonathanG | last post: by
2 posts views Thread by Adrian Parker | last post: by
1 post views Thread by Robert van Poelgeest | last post: by
1 post views Thread by =?Utf-8?B?RG9hbiBOZ3V5ZW4=?= | last post: by
1 post views Thread by XIAOLAOHU | last post: by
reply views Thread by CCCYYYY | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.