Event Mechanism in SQL Server 2008

Question

I have a windows service that constantly queries a table in DB1 and if any changes are found in it, it transfers those changes to DB2. For that, it constantly queries the DB1.

Is there any mechanism by which I can subscribe to an event in DB1 such that any changes in table is notified to the window service ?

The tables in DB1 are capture tables which have only the changed values.

Oleg Dok · Accepted Answer · 2012-01-04T13:16:22.530

4

Yes, there is such a mechanism, named Notification services, but it only valid for sql 2005, in 2008 you can use the well known other options:

SSIS
replication
Log shipping
mirroring
custom triggers and modifications queue tables

which need not the intermediate services to run with, except the last one

edited Jan 04 '12 at 13:16

answered Jan 04 '12 at 06:34

Oleg Dok

21,109
4
45
54

Notification Service is not supported in 2008. – harrisunderwork Jan 04 '12 at 12:51
Yep, sorry, so you can use another options. I'll correct the answer – Oleg Dok Jan 04 '12 at 13:05
Your answer makes it sound like the alternative options only work on 2008, whereas in fact most of them date back to at least 2005 or 2000 (e.g. replication). – Damien_The_Unbeliever Jan 04 '12 at 13:12

Event Mechanism in SQL Server 2008

1 Answers1