Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Other SQL Server Topics (2005)
 passing changed parameters to SP in Customed deliv

Author  Topic 

eladgovari
Starting Member

3 Posts

Posted - 2007-01-24 : 03:54:37
Hi,

I have created a customed delivery protocol for sending notifications to the DB using a stored procedure.

I used the code shown in :

http://msdn2.microsoft.com/en-us/library/microsoft.sqlserver.notificationservices.ideliveryprotocol.aspx#Mtps_DropDownFilterText

it all works fine except for one problem - when I want to make a change in the parameters sent to the SP, I can't do it and the original data in the corresponding fields is passed..

I tried using a XSLT file for formatting the notification before it is passed to the delivery channel, placed it in the correct path and I can even see the formatted text in the "Notification Text" field in the "NSNotificationDistribution" view. but for some reason, the values are passed as if they haven't been changed... I am a bit hopeless about it because I've tried many options and still came up with nothing...

any help would be blessed !

thanks, Elad
   

- Advertisement -