microsoft.public.sqlserver.notificationsvcs
[Top] [All Lists]

Re: using stored procedures for event rules?

Subject: Re: using stored procedures for event rules?
From: "sudhakar"
Date: 19 Apr 2006 03:40:46 -0700
Newsgroups: microsoft.public.sqlserver.notificationsvcs
No, I am not calling these procedures from within my sp. In case I need
to call is there any specific order. Any good documentation on this?

regards
sudhakar
Joe Webb wrote:
> Are you using SQLNS 2005 or a prior version?
>
> Are you calling the following stored procedures from within your
> stored procedure?
>
> NSEventBeginBatch<EventClassName >
> NSEventWrite<EventClassName>
> NSEventFlushBatch<EventClassName>
>
> or
>
> NSEventSubmitBatch<EventClassName>
>
> HTH..
>
> --
> 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 5 Apr 2006 01:22:25 -0700, "sudhakar"
> <[email protected]> wrote:
>
> >suparichithudu,
> >
> >To my understanding it is not necessary to specify sqlprovider as your
> >event provider to use stored procedures.
> >
> >Also by choosing the event provider , you are specifying how your app
> >will gather events:
> >
> >My question is regarding the eventrules that will have the logic ,
> >before you insert into notification view.
> >
> >My app is generating the said error, when it is attempting to insert
> >into the notificationview from a sp.
> >
> >TIA
> >Sudhakar


<Prev in Thread] Current Thread [Next in Thread>