[Top] [All Lists]

Re: DeliveryStatusCode Values

Subject: Re: DeliveryStatusCode Values
From: Joe Webb
Date: Tue, 28 Mar 2006 06:44:26 -0600
Newsgroups: microsoft.public.sqlserver.notificationsvcs
Hi - 

You can run the following queries in the application database to get
some descriptive information about the status codes used in SQLNS.

SELECT * FROM dbo.NSDistributorWorkItemStatusCodes

SELECT * FROM dbo.NSNotificationBatchesStatusCodes

SELECT * FROM dbo.NSNotificationDeliveryStatusCodes

SELECT * FROM dbo.NSQuantumStatusCodes

SELECT * FROM dbo.NSRuleFiringStatusCodes

SELECT * FROM dbo.NSVacuumProcReturnCodes



Joe Webb
SQL Server MVP

Get up to speed quickly with SQLNS 

I support PASS, the Professional Association for SQL Server.

On Fri, 24 Mar 2006 11:00:02 -0800, Iain Sandercock
<[email protected]> wrote:

>Hi All, 
>I'm helping one of our developers with a NS application, and during testing 
>he asked me what the various values of the DeliveryStatusCode field 
>Now, I know that a value of 6 is successfully delivered, and a value of 4 
>means that it failed, but I was wondering if anyone had an actual list (as I 
>can't seem to find a reference to the specific values and what they represent 
>- in either Technet or the NS books online)
>So, if someone does have a list (or has discovered them all through Trial 
>and error), if you could post it here, for everyone's reference  - That would 
>be greatly appreciated

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