sql server notification services: Receive notification about rows changes. -- sql server notification services

Receive notification about rows changes.

apokriffree NO[at]SPAM hotbox.ru
3/19/2007 1:26:42 AM

sql server notification services:

Perhaps somebody can point me to good step-by-step guide to solve my
very common task.
There is table "SomeTable". There is field "Status" there. Some
process need to process rows in that table when "Status"="Pending".
Of course I want to do it without checking such rows every some period
of time. I wish to accomplish that with new SQL 2005 notifications
feature. How to do it in most simple way? Please help.

Re: Receive notification about rows changes.

Joe Webb
3/19/2007 7:15:57 AM

[quoted text, click to view]

Can you elaborate a bit? SSNS may be the best route for you, but depending
on your requirements, Query Notifications, triggers, etc, could also be
the best implementation.

Joe

--
Joe Webb
SQL Server MVP
http://www.sqlns.com