Delivery Protocol Question -- sql server notification services

sql server notification services : Delivery Protocol Question

Andy
9/15/2005 8:11:17 AM

Is there a place to get the information that is stored in the
NotificationState for NotificationHeaders? Since all attributes are marked
as internal we cannot get that information out.

We are trying to build a MQ component and have Shyam's book, but we would
like to pass along the NotificationClassName since we are going to pass off
to a generic handler for processing.

Any ideas how to get this done? I am thinking to use the computed field, but
it seems that the NotificationState already identifies what I need.

kate
9/15/2005 2:09:39 PM

assumedly you have multiple notificationclasses that will be going thru
the same handler. they seem reluctant to expose the processing control
fields in earlier discussions. if you have no luck then add a constant
to the definition of all the notification classes, eg. NSclass and then
define that as field to the delivery protocol. the protocol can have
any data field that is defined for the notification classs so that
should work (in theory)

Kate MBCS

Alert Technologies
http://www.alert-technologies.co.uk
Get your notification services implementation going in minutes not
weeks ......

Andy
9/16/2005 12:40:49 PM

That is what I am doing, adding a Field to the protocol that passes what I
need. I have had to write a lot of debugging statements to write to a text
file to help find what is actually getting passed. There has got to be a
better way to debug.

[quoted text, click to view]

kate
9/16/2005 2:25:45 PM

andy, have you tried attaching to the NSservice process, from your
custom protocol in visual studio. set NS to load the assembly from your
debug build output folder and then restart the NS service. attach the
VS debugger and you can set break points then and follow the code
through as it is called. works well .

kate

alert tech

Andy
9/19/2005 12:04:30 PM

I have not tried that. I am using a remote box for my development since some
of our data is too large to put on my dev box. I will have to see how I can
get it configured to run on my local box.

Thanks for the insight.

[quoted text, click to view]

Andy
9/22/2005 12:31:12 PM

Ok I have tried, but it does not work for me. Do you mind giving a
step-by-step of what to do? My other error logging is working, but I would
love to be able to debug through VS. I am using SQL 2005 NS and VS.Net 2005
beta 2. The version should not matter, I simply need the steps you take.

Thanks Kate.

[quoted text, click to view]

Andy
9/23/2005 7:28:20 AM

I got it figured out, just select the process in the debugger and attach my
project to that.

[quoted text, click to view]

kate
9/26/2005 1:18:37 AM

good to hear you have that working now. absolutely, invaluable when
working on custom extensions for NS.

Kate MBCS

Alert Technologies
http://www.alert-technologies.co.uk
Get your notification services implementation going in minutes not
weeks ......

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about sql server notification services

home · blog · groups

Questions? Comments? Contact the dn