Polling in 2005

Hi folks,

Somebody got an idea about how to implement the following in SQL 2005? Or does anybody know of an example posted somewhere for this? In my opinion it's such a common problem, someone somewhere is bound to have written something about this somewhere (but I could nog find it).

We've got a table in a database and regularly an event happens that inserts a record in this table. At that moment a signal should be given to a .NET-service (in the form of a XML-message) which will do some intelligent stuff with this info.

In SQL 2000 I would implement a polling mechanism that every 10 secs (or some other appropriate interval) would do a select on the table to see if anything had changed. But with all the new features in 2005, I'm of the opinion that this could be done differently.

I've been looking at:

Notification Services, but this looks a bit like overkill for such a simple demand.
Query notifications from the Service Broker. But this is also a bit much because deletes are also a cause for a notification. Also all the articles I found are dealing with cache expiration. (Afterthought... maybe SELECT MAX(id) will work as defined query)

Ofcourse it would be nice if the signal is queued somewhere when the receiving service is temporarily not available.

Thanx in advance,

Lexwant to give us a why and what you are trying to do?

I might have a trigger fire into a log table and then take action on that...but I don't see a need|||To put a simple, a bunch of different processes can insert records in a table indicating a document is ready to be processed. Each time a new record is added a signal has to be sent to a .NET-service (in XML-form). This signal will process the document further.

Happy holidays...

Please vote/validate SQL SSAS bugs on connect.microsoft.com

Folks,

It might help to get SQL 2005 issues addressed in more expedited fashion if we go to https://connect.microsoft.com/SQLServer (Click where it says "1. Click Feedback here" to enter feedback area.
search for analysis services bugs
review bugs that are filed
rate bugs by votingvalidate bugs that you've seen.

This is an excellent suggestion.

If you have any problem you are seeing, please go to the Connect (http://connect.microsoft.com/sql) and please file it.

Please make sure you describe problem in much detail as possible so we can reproduce it. Every problem filed is getting looked at. It is very important that problem description is accurate. Leave your contact information in case you'd like to get notificaitons about the problem. If you still concerned, feel free to post on this forum. Members of Analysis Services team are looking at your questions and concerns and will try to help you.

Edward Melomed.
Program Manager. SQL Server Analysis Services.
--
This posting is provided "AS IS" with no warranties, and confers no rights.