In a prior post

http://forum.strataframe.net/Topic5041-6-1.aspx?Highlight=Notification

You mentioned that you support SQL 2005 Notification Services.   Is this a native BO function or just based on the fact that SQL Server 2005 Ntification Services produces SQL?    I was looking for the samples or section in the help and did not find anything.

Thanks,

Richard

Ahhh,  I just started looking at the DDT and saw that checkbox.   Man you guys are fast.

Thanks,

Richard

Well, we try

Just FYI....I thought I would add that you may want to use this sparingly.  By turning on a broker service you are increasing the amount of resources required for the database to respond.  Also, if you register too many notifications, you will also impact the performance of the database. 

Hi,

What are the common usage of notification service, auto requery BO populated combobox/list if any update at database?

Thank you

Yes, the most common use for Query Notification Services is for requerying lookup data and such and to avoid concurrency issues.  Say you have created an appointment scheduling program... if two people side-by-side are creating appointments, then you would want the changes by one user to be reflected on the other user's screen, either by polling the server for changes or by registering a query notification.