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

Re: using stored procedures for event rules?

Subject: Re: using stored procedures for event rules?
From: Joe Webb
Date: Mon, 10 Apr 2006 07:02:01 -0500
Newsgroups: microsoft.public.sqlserver.notificationsvcs
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>