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

Re: DeliveryStatusCode Values

Subject: Re: DeliveryStatusCode Values
From: Iain Sandercock
Date: Tue, 28 Mar 2006 07:53:38 -0800
Newsgroups: microsoft.public.sqlserver.notificationsvcs
Hi Joe, 

Thankyou for this, this is exactly what I was looking for, and no doubt will 
be useful for others as well

Thanks again

Cheers

Iain

"Joe Webb" wrote:

> 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
> 
> HTH...
> 
> Joe
> 
> 
> -- 
> 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 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 
> >reflected..
> >
> >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
> >
> >Thanks
> >
> >Cheers
> >
> >Iain
> 

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