Thank you for your reply. I want to fetch the results of counters in my
stored procedure. I mean I want know when exactly the notification generation
by sql provider.
"Joe Webb" wrote:
> There are component level objects that provide information about the
> Distributor, Delivery Channels, Event Providers, and Generator.
>
> Here are some links to SQL Server 2005 BOL.
>
> ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/sqlntsv9/html/ab553c22-329d-480c-ad77-b898cd761adb.htm
> ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/sqlntsv9/html/ac05465a-1b29-4d1f-acb3-1826d9fa5299.htm
> ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/sqlntsv9/html/80159049-eb12-4d05-ab72-caac856bffde.htm
> ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/sqlntsv9/html/8c212998-caf7-4f3a-8ff2-9a94719b3dae.htm
> ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/sqlntsv9/html/cf9c80b0-c8b5-47d2-8d90-692a26080739.htm
>
>
> Are you looking for something beyond these Performance objects?
>
> --
> Joe Webb
> SQL Server MVP
>
http://www.sqlns.com >
>
> ~~~
> Get up to speed quickly with SQLNS
>
http://www.amazon.com/exec/obidos/tg/detail/-/0972688811 >
> I support PASS, the Professional Association for SQL Server.
> (
www.sqlpass.org)
>
> On Tue, 24 Jan 2006 06:01:02 -0800, R.D <RD@discussions.microsoft.com>
> wrote:
>
> >Hi all
> >Can anyone tell me how to know that the events generation is finished and
> >notification generation has started. or the ns is doing distribution of mails.
> >
> >I would like to know what exactly ns is doing(at what stage it is)
> >programmatically is it possible.
> >
> >Thanks in advance
