SQL Server's Data Change Notification

[Nick Pritchard]

Well, there are a couple ways you could do that.

You could write a windows service with a
System.Timers.Timer object, that fires an event ever 15
minutes. Or, you could use a trigger on the table you are
evaluating. On update for your table, your trigger fires
executing a piece of code that could be a SQL job, or an
actual executable you had written in VB or VB.net. The
easiest programatic way would probably be the service
though.

Cheers...

-----Original Message-----
I am writing a little vb/vb.net application to check every15 minutes if a record or certain records have changed in
a specific table, If record/records have changed then getthe index of that record. What is the best way to
accomplish this task? Any ideas or source code samples
would be highly appreciated.

I am using vb.net with SQL Server 2000, vb6 is also
available to me.
Thanks
.

[Mo Quamar]

-----Original Message-----
Well, there are a couple ways you could do that.

You could write a windows service with a
System.Timers.Timer object, that fires an event ever 15
minutes. Or, you could use a trigger on the table you are
evaluating. On update for your table, your trigger fires
executing a piece of code that could be a SQL job, or an
actual executable you had written in VB or VB.net. The
easiest programatic way would probably be the service
though.

Cheers...

-----Original Message-----
I am writing a little vb/vb.net application to check

every

15 minutes if a record or certain records have changed ina specific table, If record/records have changed then

get

the index of that record. What is the best way to
accomplish this task? Any ideas or source code samples
would be highly appreciated.

I am using vb.net with SQL Server 2000, vb6 is also
available to me.
Thanks
.

.
Thanks for you reply.

Yes, I am writing this process using Windows Servce and
using Update Trigger, how do I know which record has
changes?

[Alexander]

The most easy way is to create a table and inset in it a record index and
change time on trigger event.
Then your service can red this table and empty it, or keep it and just
select after particuar time.

Code can look like:
CREATE TRIGGER watchTrigger
ON <table_name, sysname, pubs.dbo.sales>
FOR INSERT, UPDATE
AS
BEGIN
insert watchTable ([ID], ChangeTime) select [ID], getdate() from inserted
END
GO
"Mo Quamar" <mq*****@cprk.com> wrote in message
news:03****************************@phx.gbl...

-----Original Message-----
Well, there are a couple ways you could do that.

You could write a windows service with a
System.Timers.Timer object, that fires an event ever 15
minutes. Or, you could use a trigger on the table you are
evaluating. On update for your table, your trigger fires
executing a piece of code that could be a SQL job, or an
actual executable you had written in VB or VB.net. The
easiest programatic way would probably be the service
though.

Cheers...

-----Original Message-----
I am writing a little vb/vb.net application to check

every

15 minutes if a record or certain records have changed ina specific table, If record/records have changed then

get

the index of that record. What is the best way to
accomplish this task? Any ideas or source code samples
would be highly appreciated.

I am using vb.net with SQL Server 2000, vb6 is also
available to me.
Thanks
.

.
Thanks for you reply.

Yes, I am writing this process using Windows Servce and
using Update Trigger, how do I know which record has
changes?