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

Re: Trapping errors in Event subscription rule

Subject: Re: Trapping errors in Event subscription rule
From: Joe Webb
Date: Tue, 25 Apr 2006 06:59:18 -0500
Newsgroups: microsoft.public.sqlserver.notificationsvcs
Anything in the event log? For more info on how configure the logging
levels, set
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/sqlntsv9/html/ba1164a1-b965-48ff-9b86-da92f519be54.htm
in BOL. 

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 22 Apr 2006 06:31:09 -0700, "sudhakar"
<[email protected]> wrote:

>Hi all,
>
>I am using a stored procedure for my event subscription rule. This
>procedure essentially inserts data into Notifications view by selecting
>data from the chronicle tables.
>My code is now freezed including the  ADF,ICF and stored procedure .
>
>The problem I am having is with my deployment.
>
>With the same set of files, deployment works some times and doesn't
>some other times.
>I go debugging and find that when things do not work, the statements
>within my event subscription rule. are not executed.
>
>I am not using any EventSubmit<ClassName> procedures from within my sp.
>The reason being the same procedure works , say 2 out of 4 attempts to
>install new NS instances.
>
>Any way to figure out whats going wrong when things are'nt working?
>
>Thanks in Advance
>
>sudhakar

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