On Mon, 14 May 2007 03:12:28 -0700, Ronald Green wrote:

> Hi,
>
> I'm a seasoned DBA and developer, but not quite familiar with SSNS so
> please forgive my ignorance... :)
>
> I understand that SSNS notification of SQL related events is actually
> implemented as polling of the database for changes.
>
> Is it true? If so, what is the minimum polling delay? Also, is it
> possible to use activation (via Service Broker and triggers) with SSNS
> instead of polling?
>
> Thanks in advance,
> R. Green

On May 15, 8:53 pm, Joe Webb <j...@webbtechsolutions.com> wrote:
> On Mon, 14 May 2007 03:12:28 -0700, Ronald Green wrote:
> > Hi,
>
> > I'm a seasoned DBA and developer, but not quite familiar with SSNS so
> > please forgive my ignorance... :)
>
> > I understand that SSNS notification of SQL related events is actually
> > implemented as polling of the database for changes.
>
> > Is it true? If so, what is the minimum polling delay? Also, is it
> > possible to use activation (via Service Broker and triggers) with SSNS
> > instead of polling?
>
> > Thanks in advance,
> > R. Green
>
> Hi Ronald -
>
> Good question. The built-in SQL Server Event Provider does essentially
> collect data by polling. The frequency is configurable.
>
> However you can always create your own custom event provider if the
> built-in provider does not fit your needs.
>
> HTH...
>
> --
> Joe Webb
> SQL Server MVPhttp://www.sqlns.com