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

Re: DeliveryStatusCode Values

Subject: Re: DeliveryStatusCode Values
From: "CoreyB"
Date: 24 Mar 2006 11:45:08 -0800
Newsgroups: microsoft.public.sqlserver.notificationsvcs
I think this is what you're looking for:

select * from applicationdatabase.dbo.nsnotificationdeliverystatuscodes

returns.......


NotificationDeliveryStatusCode     Description
0       Delivery never attempted: first try pending
4       Delivery failed
6       Delivery succeeded


Iain Sandercock 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>